SQL Selecting dates with maximum sale for each department
Fetch the row which has the Max value for a column
Is there any canon reference to the Mirror Universe Borg that would explain more about them?   I've tried searching on my own and haven't found anything. Question about $\lim _{q \rightarrow \infty}\|f\|_{q}=\|f\|_{\infty}$ Let $(X,B,\mu)$ be a complete measure space,Show that $$\lim _{q \rightarrow \infty}\|f\|_{q}=\|f\|_{\infty}, \quad \forall f \in \bigcup_{p} \bigcap_{p \leqslant q&lt;\infty} L^{q}$$ So,$\lim _{q \rightarrow \infty}\|f\|_{q}$ , $\|f\|_{\infty}$ are equal-norm with space $ L^{\infty} \cap\left(\bigcup_{p} \bigcap_{p \leqslant q} L^{q}\right)$. Case 1: $m(X)&lt;\infty $.It's easy to prove that. Case 2: $m(X)=\infty $. I have no idea about it,And I started to doubt the correctness of this conclusion. Can somebody give me a hint for this problem or just give an example to prove that this is a wrong conclusion when $m(X)=\infty $. Thanks in advance. How can I determine which process owns a hotkey in Windows? Given a hotkey, how can I find which program owns it? How can I fade tabs in & out with the Twitter Bootstrap framework? How do I install a different Python version using apt-get? find command with regex quantifier e.g. {1,2} I have been trying to create a find command string that will find all files that end with a number 1-99 but exclude all others.  e.g. I want to find myfile1 myfile99 but not myfile456 and not myfilebackup  The regex I'm thinking of is myfile[1-9]{1,2} but I can't get this to work with find.  find . -regex '.*myfile[0-9]{1,2}' OR  find . -iname 'myfile[0-9]{1,2}'  From what I can see it's the {1,2} part that is not working.  (by the way can you use -name -regex interchangably?)  Any help appreciated. Today I was going through my text book exercise and got hold of the following question.     Let $X$ be a normed linear space with norm $\lVert\cdot\rVert$ and $A$ is a non empty convex subset of $X$ then prove that $\operatorname{Closure}(A)$ is also a convex subset of $X$.   I gave it a try but could not succeed. I am trying to prove this inequality  $$|e^z-1|\leq e^{|z|}-1\leq |z|e^{|z|}$$  I've tried calculating the difference in their power series   $$\sum_{k=0}^\infty\frac{|z|^k}{k!}-1-\left|\,\sum_{k=0}^\infty\frac{z^k}{k!}-1\,\right|$$   but did not get anywhere. Multiple entry visa to UK (sponsored visitor) I tried to use sudo cd name_of_dir but am getting the error message:   sudo: cd: command not found   Is there any other way to enter a directory owned by another user which has 700 permission? We know that $\displaystyle\zeta(2)=\sum\limits_{n=1}^{\infty} \frac{1}{n^2} = \frac{\pi^2}{6}$ and it converges.        Does there exists a bijective map $f:\mathbb{N} \to \mathbb{N}$ such that the sum $$\sum\limits_{n=1}^{\infty} \frac{f(n)}{n^2}$$ converges.      If our $s=2$ was not fixed, then can we have a function such that $\displaystyle \zeta(s)=\sum\limits_{n=1}^{\infty} \frac{f(n)}{n^s}$ converges What’s the point in having “www” in a URL? Other than for historical reasons, is there is reason to have “www” in a URL?  Should I create a permanent redirect from www.xyz.com to xyz.com, or from xyz.com to www.xyz.com? Which one would you suggest and why? How many switches can be stacked/interconnected? Why does prime factorization for LCM work? A method to finding the LCM of two numbers is to use prime factoring. I know how to do this, but logically why does this work in finding the lcm Reference for statistical mechanics from information theoretic view I am interested in knowing if some one here knows book/notes for statistical mechanics from the information theoretic viewpoint.  Additional Request from user83014  "Jaynes wrote a paper called Information theory and statistical mechanics (1957). I tried to read this but found it somewhat hard to follow, and I suspect it's because it's one of the earlier works, and that a modern text might be more refined since we've had time to work it out. On the other hand, what I've read from physics textbooks don't explicitly talk about information theoretic concepts like shannon entropy.  "Is there a good modern introduction to the information theoretic view of entropy?" Different results between individual and batch clip of rasters in QGIS? Do these leaves signify anything? Get the cartesian product of a series of lists? So I was playing around on Area 51 hoping for further news on the private beta for ebooks, and noticed that my avatar (a hand) was missing. Also the Area 51 has the old toolbar. So I looked at the flair page. The network flair has my hand, the Area 51 flair has a quilt. OK, so time to upload a new image, and WordPress -- WordPress -- I don't want to login to WordPress. Any idea what's up with that?  The following questions did not help, and have different causes and symptoms: How to style text in hyperref \url? I want to set color, font and similar style attributes for the text in a \url from the hyperref package. How do I go about doing it? All I have found are . I want to because I am using ttf fonts for my texts and I want my urls to be in that ttf and not the default (typewriter font?) that the hyperref package gives me. I started with just trying to get it in italics but didn't even succeed with that:  \documentclass{memoir} \usepackage{hyperref} \begin{document} Lala \url{\itshape www.example.com}. \end{document}     I am guessing there is some hook or something but I just can't find it. Maybe I have gone blind?