I'm trying to get the greatest value of just 1 row (mult columns). All of the tutorials I've watched are for multiple rows.  How can have just the greatest value (4943) returned? Thanks!
How do you return 1 value per row of the max of several columns:  TableName  [Number, Date1, Date2, Date3, Cost]   I need to return something like this:  [Number, Most_Recent_Date, Cost]   Query?
What are the relationship between administrators groups of domain, dev computer and of Sharepoint services? I know-know I can search and read but anyway I would need to ask in order to escape possible typos, personal misunderstandings and to better remember.     I develop on a machine with installed Sharepoint 2010 Sever where I have local groups:     Administrators Description: Administrators have complete and unrestricted access to the computer/domain   WSS_Admin_WPG Description: Members of this group have write access to system resources used by Microsoft SharePoint Foundation      **Does the description of "Administrators" ("computer/domain") imply all privileges of "WSS_Admin_WPG" ?    Does the description of **WSS_Admin_WPG (in part of "system resources used by Microsoft SharePoint Foundation") imply Sharepoint Server?**    The WSS_Admin_WPG group has entries of:     "BUILTIN\Administrators (S-1-5-32-544)" group   and some user domain accounts   Is "BUILTIN\Administrators (S-1-5-32-544)" group the same (alias to?) as "BUILTIN\Administrators" entry I observe among Sharepoint Farm Administrators (through "Central Administration")?       Is the entries of domain accounts excessive (or necessary)     in "WSS_Admin_WPG" if these accounts make part of "Administrators" group?     in "Farm Administrators" if these accounts are part of "BUILTIN\Administrators (S-1-5-32-544)" group?     What are relationship (difference) between "BUILTIN\Administrators" and "Administrators"? Let $R$ be a commutative ring with 1, we define  $$N(R):=\{ a\in R \mid  \exists k\in \mathbb{N}:a^k=0\}$$  and  $$U(R):=\{ a\in R \mid a\mbox{ is invertible} \}.$$  Could anyone help me prove that if $a\in N(R) \Rightarrow 1+a\in U(R)$?  I've been trying to construst a $b$ such that $ab=1$ rather than doing it by contradiction, as I don't see how you could go about doing that. "who" vs. "whom" and when to omit the relative pronoun This is the boy who was asked by the teacher to stay back after school. This is the boy whom the teacher asked to stay back after school. This is the boy the teacher asked to stay back after school.   Are the sentences above correct ? Algorithm to detect overlapping periods I would like to be able to copy and paste text in the command line in Bash using the same keyboard bindings that Emacs uses by default (i.e. using C-space for set-mark, M-w to copy text, C-y, M-y to paste it, etc.).  The  says that Bash comes with some of these key bindings set up by default.   For example, yanking (C-y) works by default on my terminal. However, I can't get the set-mark and copy commands to work, and they don't seem to be bound to any keys by default.  Usually, the way a user can define her own key bindings is to add them to .inputrc. So I looked and found the following bash functions in the documentation that I presume can help me define the Emacs-like behavior that I want (i.e. set-mark with C-space and copy with M-w).  copy-region-as-kill ()      Copy the text in the region to the   kill buffer, so it can be yanked right   away. By default, this command is   unbound.   and    set-mark (C-@)      Set the mark to the point. If a   numeric argument is supplied, the mark   is set to that position.   If I understand correctly, the above means that copy-region-as-kill is not bound to any keyboard sequence by default, while set-mark is bound to C-@ by default.   I tried C-@ on my terminal, but I don't think it runs set-mark because I don't see any text highlighted when I move my cursor. In any case, I tried adding  keyboard bindings (M-w and C-) to the functions  copy-region-as-kill and set-mark above in my .inputrc and then reloading it with C-x C-r, but this didn't work. I know that my other entries in .inputrc work because I have other user-defined keybindings defined in it.  Is there anything I am doing wrong? Am I missing anything? I need to get rid of the GNOME Desktop Environment which has been installed by default when I updated my pc from 15.10 to 16.04.  After a while, I found myself not only with GNOME DE, but also with Cinnamon alongside (in the login screen, I could choose at least five or six DE!)  Now I am using Unity, and I'm happy with that, and I successfully uninstalled Cinnamon, but now I'm afraid that after uninstalling GNOME I will mess up the Unity DE, since I see many packages running in unity with the packagename starting with gnome-... Would someone mind to help me? Thx in advance What is the formula for Real vs Apparent Depth, when not looking perpendicular to the interface?   I know the formula $$\frac{\text{real depth}}{\text{apparent depth}}=n$$   but I'm not looking for this. I'm trying to prove that  $$ \left| \frac{1}{x}-\frac{1}{y} \right| $$  is a metric on $X = \mathbb R^+$.  The properties of non-negativity and symmetry are obvious (do I actually even need to prove them?), but the tricky one is, as usual the inequality property, i.e.  $$ d(x,z) \le d(x,y) + d(y,z) \text{ for any } z \in X. $$  So, ok, I have that  $$ d(x,z) \le d(x,y) + d(y,z) \\ \iff \left| \frac{1}{x}-\frac{1}{z} \right| \le \left|\frac{1}{x} - \frac{1}{y} \right| + \left|\frac{1}{y} - \frac{1}{z} \right| \\ \iff \left| \frac{1}{x} \right|- \left| \frac{1}{z} \right| \le \left| \frac{1}{x}-\frac{1}{z} \right| \le \left|\frac{1}{x} - \frac{1}{y} \right| + \left|\frac{1}{y} - \frac{1}{z} \right| $$  ...and that's about as far as I've gotten–which is to say, not very far. I also tried multiplying both sides by $ \left| \frac{1}{x}-\frac{1}{z} \right| $, but that wasn't very fruitful. If someone could point me in the right direction, it'd be greatly appreciated. Thanks. vertical spacing in nested fraction I have complicated math expression:    Vertical spacing between text and fraction line is too small. I tried to define new \frac command (with amsmath package) with adjustable vertical spaces. As you can see, the result is not satisfying:    \documentclass[a4paper,fleqn,leqno]{article} \usepackage{polyglossia} \usepackage{color,pifont,fontspec} \usepackage[top=2.54cm,bottom=2.54cm,left=2.54cm,right=2.54cm]{geometry} \usepackage{tikz,tikz-3dplot,graphicx} \usepackage{mathtools,breqn,amsmath} \usepackage[fontsize=12]{scrextend} \usepackage{array,multirow} \usepackage{pgfplots} \DeclareMathSizes{12}{14}{14}{10} \newcommand{\myfrac}[3][0pt]{\genfrac{}{}{}{}{\raisebox{#1}{$#2$}}{\raisebox{-#1}{$#3$}}} \begin{document} \begin{dmath*}[breakdepth={0},style={\mathindent=0pt},spread={10pt}] {n=\myfrac[3pt]{\myfrac[3pt]{0,0625N+0,0215}{2}-0,043}{\myfrac[3pt]{\myfrac[3pt]{\scriptstyle 0,0625N+0,0215}{\scriptstyle 2}-0,043}{\myfrac[3pt]{\scriptstyle N}{\scriptstyle 2}-1}+0,0215}} \end{dmath*} \end{document}   How can I enlarge verticall spacing in whole fraction? Requesting an active user page In my opinion, providing us with an active user page that shows the list of recent active users is useful as we can monitor the active users without visiting each user profile.  The list can be arranged in a grid of m rows by n columns and accompanied by labels representing the their reputations (and other info that you think they are important) and activities  such as "seen 2 minutes ago".  The following figure illustrates my idea. I am sorry. There is a typo in the following figure, Active must be changed to active to make it parallel to the other existing labels.     I think it is not too difficult to implement this. By adding a new action method and editing the view, done!  Of course it is not urgently requested feature. If it is useful, it can be put in the development to-do list so it can be implemented together with other useful requests at once.  Any responses are welcome! Regardless of how difficult it is, could you explain whether or not there are negative effects of this request? Down voting without informative comments looks barbaric. :-)  Edit:  If it is about user privacy, why is there a "seen 2 minutes ago" in the user profile page? I don't think there is a difference if we implement this feature. How can one rig a Stirling engine? (Piston) I've only done a very little animation and rigging before, and I keep getting stuck trying to rig the pistons and rotor of the Stirling engine I built.     What should happen is that one piston moves in as the other moves out, and through the attached arms, the rotor should spin. Animating the rotor and the piston heads was easy enough, but getting the arms that go from the piston heads to the end of the shaft arm to move right endlessly confuses me.   Each end of each arm moves differently over the course of a cycle. With animating, I can't figure out how to interpolate so the arms stay where they should.  With armatures, I have tried for a while, but keep getting stuck when it comes to how to have one end of a bone moving in a circle while the other end is moving in a straight line.  Edit: The answer below elegantly resolved my problem, so i've updated this with the finished .blend file in case it's useful someone else.   Here is the .blend file: ICS devices support creating backups using adb backup, and restoring them using adb restore. Using adb backup, one can select that everything should be backed up, or only a certain package.  However, adb restore lacks all the options of adb backup. When I call adb restore backup.ab, where backup.ab is only the backup of a single package, the phone shows me a warning dialog saying that all settings are going to be lost after restoring the backup. Is it true that restoring a single package backup wipes all data on the phone? If yes, is it somehow possible to restore a single package using adb restore? Office 2016 Advanced Setup How is the nature of logical principles commonly defined in contemporary philosophy? In contemporary philosophy, how exactly is the nature of logical principles defined? For example, the way I've commonly seen logical principles construed are as true propositions which described the most general laws of reality. The previous definition does seem very intuitive to me; if we understand logical principles as being concerned with truth, and if we accept a correspondence theory of truth, then logical principles simply describe fundamental laws regarding various states of affairs occurring in reality. (e.g. If state of affairs S1 obtains and state of affairs S2 obtains, then state of affairs S3 must also obtain given logical law L).  However, I've mostly heard the previous view expressed among laypersons. I'm interested to know how most philosophers would think about the nature of logical principles. Subcaption defaulting to capital letter labels? I seem to be having a unique problem. There are many questions asking about how to change subcaption to a label with capital letters but for me my program is defaulting to capital letters when I would prefer lowercase.  My preamble  \documentclass[12pt,reqno]{amsart} \setlength\parindent{0pt} %no auto indentation for new paragraphs \usepackage{geometry}  \geometry{a4paper}  \usepackage{natbib}  \usepackage[latin1]{inputenc} \usepackage{amsmath, amsthm, amssymb, calc, dsfont}    \usepackage{enumerate} \usepackage{subcaption, caption, graphicx} %figure packages \usepackage{authblk} %author affiliations \usepackage{setspace, lineno} %double spaced etc. options, line numbering  \usepackage{tikz} \usetikzlibrary{shapes,arrows,chains,automata,positioning}   My figure  \begin{figure}[h!]   \centering   \begin{subfigure}[]{0.48\textwidth}           \includegraphics{Figure1.pdf}           \caption{}           \label{FigPractice}    \end{subfigure}    \begin{subfigure}[]{0.48\textwidth}           \includegraphics{Figure2.pdf}           \caption{}           \label{PracticeAge}   \end{subfigure}   \caption{a caption} \end{figure}   I've also tried \renewcommand{\thesubfigure}{\alph{subfigure}} I'd like to create a Gmail filter to filter all of my Google Calendar notifications into a separate folder.  Google Calendar notifications have headers that look like the following:  Reply-To: Helen Seu &lt;h...@g...com&gt; Sender: Google Calendar &lt;calendar-notification@google.com&gt; Auto-Submitted: auto-generated Date: Thu, 01 May 2014 05:25:28 +0000 Subject: Updated Invitation: Mobile design review @  Fri May 9, 2014 3pm - 4pm From: Helen Seu &lt;h..@g...com&gt; To: "Mike Burton" &lt;m...@g...com&gt;,    In particular, the email Reply-To is the user who created the meeting, and the Sender is calendar-notification@google.com.  For some reason, Gmail does not seem to allow you to filter on the Sender field of an email. Is there another clever way to filter Google Calendar notifications to a separate folder? How can I evaluate $$\sum_{n=1}^\infty\frac{2n}{3^{n+1}}$$? I know the answer thanks to , but I'm more concerned with how I can derive that answer. It cites tests to prove that it is convergent, but my class has never learned these before. So I feel that there must be a simpler method.  In general, how can I evaluate $$\sum_{n=0}^\infty (n+1)x^n?$$ Take a look at the following picture:   Why does the light at the bottom of the water form this pattern? I have also seen the same phenomenon in all the swimming pools I've ever visited, of whatever depth they may be. How does this happen? Normal subgroup of prime index Why do reputation drops not highlight the Achievements icon? The "Recent achievements" icon (looks like a bar graph in the top bar for signed in users) doesn't highlight when one only has recent reputation losses.  I'd like it to highlight whenever my reputation changes, positive or negative - in fact I'd suggest it's far more important for me to review posts that get a downvote than those that got an upvote.  Is there a reason negative reputation events don't cause it to highlight?