Get entire row when group an ID in MySQL
How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
Is $\mathbb{Z} \left[ \frac{1+i \sqrt{7}}{2} \right]$ euclidean? 0 ram free on ICS Consecutive spoiler blocks (>!) are shown as blockquotes The markdown &gt;! a  &gt;! b  &gt;! c  Will be shown as a blockquote with ! in front of it:   a    b    c  Instead of a spoiler for 3 paragraphs (or 3 spoiler blocks, whatever). After the performance problems we have run into with  we've decided to make a change, we're moving the network on to .  Here's where to get started:   What works:   All search operators should be in Many changes below from the old search behavior   What's different:   The new search is AND, adding a search term will narrow your results, not expand them. The look of search results is now more unified with the following differences between Q&amp;A:   "Q:" or "A:" prefix Answer counts and tags will be present in questions. The answer count will be highlighted in green if it's accepted. (We may index other things later, that's why the results are more generic/google-y now.)  It's faster, about 5-10x faster for almost all searches on large sites like Stack&nbsp;Overflow Quoted phrases are exact matches except for case-sensitivity, for example,  or . If not in a quoted phrase, words will now be stemmed () Snippets for context will now be more relevant Excludes are now explicitly supported (like -term and -"my phrase") We don't roll up to the question anymore, if you searched for something that matched an answer, we'll show you the answer directly in search results The search per minute limit is effectively gone, it'll block a bot, but no one else should hit it... We'll be monitoring performance though infavorites:mine is back, with infavorites:12345 (any user id) added   What needs work:   What you tell us is broken... Do your worst.   Testing, not yet final:   New range support, here are some examples:   answers:1..1 (exactly one answer) answers:10..20 (10 to 20 answers) created:2008..2009 (created between Jan 1st, 2008 and Dec 31, 2009) created:2010-04..2010-05 (created between April 1st, 2010 and May 31st, 2010) created:2011-01-05..2011-01-06 (to be clear: it goes to end-of-day) This range syntax applies to a new advanced operator: lastactive: and the other numerical ranges, views:, and score:  Additionally, the above syntax is a bit more flexible if you forget it exactly (e.g. score:20-30) in an effort to be intuitive as possible, give it a try - tell us what you think.    I'll try and improve the search as much as possible before it becomes default... At the very least we want it equivalent in relevance and functionality before the switch, but ideally much better. We won't switch until then.  Please give it a try, tell us what you think here, and we'll continually improve it over the holidays as time allows. Bear in mind you may get a search offline page during this test if a change we're making for results necessitates a reindex, and even that should only last about two minutes here on Meta&nbsp;Stack&nbsp;Overflow.  Give it your worst, compare results to the old search, tell us what's better and what's not. We look forward to the feedback.  Update The new search is now the default across the network - we'll be monitoring things over the next few days and would appreciate reports of any crazy behavior you see here. Constants and compiler optimization in C++ I've read all the advice on const-correctness in C++ and that it is important (in part) because it helps the compiler to optimize your code. What I've never seen is a good explanation on how the compiler uses this information to optimize the code, not even the good books go on explaining what happens behind the curtains.    For example, how does the compiler optimize a method that is declared const vs one that isn't but should be. What happens when you introduce mutable variables? Do they affect these optimizations of const methods? I'd like to install a  client for Xubuntu (12.04).  I'm getting non-English Google results, and I didn't find  in the Xubuntu repositories.   Does anyone know of a client that works well for Ubuntu or it's supported derivates (or installation instructions for grive?) Currently, the number of "votes cast" excludes votes on deleted content. Once something gets deleted that you voted on, that vote vanishes from your stats. This of course happens frequently especially with down-votes - if you're a good voter, stuff you downvote often ends up getting deleted.  Seeing as the idea behind the public display of total votes you've cast is to encourage voting, is this really fair?   Also, doesn't it distort greatly all voting stats, especially when looking at candidates for moderator elections and such? "Reality" of EM waves vs. wavefunction of individual photons - why not treat the wave function as equally "Real"? In thinking how to ask this question (somewhat) succinctly, I keep coming back to a Microwave Oven.  A Microwave Oven has a grid of holes over the window specifically designed to be smaller in diameter than the wavelength of the microwaves it produces, yet larger than the wavelengths of the visible light spectrum - this is so you can watch your food being heated without getting an eye full of microwaves.  The "realness" of electromagnetic waves seems indisputable - both from the microwave example above, and also because if I want to broadcast a radio wave with a certain wavelength, then I need to make sure I have an antenna of corresponding length to produce the wave I'm looking for.  Furthermore, we discuss and treat these waves as real, measurable "objects" that exist and can be manipulated.     Now, if I want to describe the behavior of my Microwave Oven in the framework of QM (let's pretend my oven is going to only produce 1 photon of energy corresponding to a wavelength of the microwave spectrum for simplicity) then I'll describe the behavior of that photon as a wavefunction that evolves over time and gives a probability distribution within my microwave that similarly does not allow the photon to pass through the safety grid and exit the oven cavity giving me a retinal burn.  The difference is, the wavefunction is never treated as something "real" in this description.  When the safety grid is described as working to protect you because it has holes smaller than the wavelength of the classical waves it's blocking, this is a useful description that seems to describe "real" objects/be-ables.  While it is possible to describe why an individual photon has low probability of passing through the same grid but extended physical properties such as wavelength (in space) are treated as non-real because we're dealing with a point particle and with behavior described by something we also treat as non-real (the wavefunction); it seems unclear to me why we insist this wave function which predicts behavior of physical measurements so well is somehow "non-real."    Put another way, if we have no problem treating EM waves as "Real," then why do we insist on treating the wavefunction that describes the same behavior as "unreal?"  I understand there is recent research (Eric Cavalcanti and his group for one) trying to argue this point, but as every respectable physics professor, I've ever encountered, has treated the wavefunction as an indisputably non-real mathematical tool, I needed to ask this community for an answer. How do I get Perl to read the contents of a given directory into an array?   can do it, but is there some method using 'scandir' or a similar term? Windows 7 won't boot after installing Ubuntu 11 What should I do, as my submitted paper is still under review after 1 year? How can I have 2 different mod folders with the new Minecraft launcher? Calculate a determinant with pattern How long does mana from Burning-Tree Emissary stay around? Does mana added to your pool from  get destroyed when the card that added it is destroyed? Long sites break the layout on the front page The long name pushes the stats to a weird place. And what's with the "Stack Exchange" at the end anyway? After my suspension period, my reputation was not returned On Stack Overflow, I have a suspension period of 7 days which ends today. But my actual reputation has not been returned to me as one of the moderators said it would. I have a message like this by @Andrew Barber:     Once your suspension period is over, you will be returned to your   correct reputation level, minus the votes from the accounts which have   been deleted. At that time, you are more than welcome to return, and   continue contributing your knowledge, and gaining legitimate   reputation points. Just please keep our rules in mind when you do.      Regards      Andrew Barber, Stack Overflow moderator   Can any moderator here help me or tell me what the rules are of getting back my reputation?  How can I get the attention of a moderator so that they can resolve my problem? In Unity, are there any pre-defined shortcuts, e.g. to open the dash or unhide the launcher? GOTO still considered harmful? Everyone is aware of Dijkstra's  (also  .html transcript and  .pdf) and there has been a formidable push since that time to eschew the goto statement whenever possible. While it's possible to use goto to produce unmaintainable, sprawling code, it nevertheless remains in . Even the advanced  control structure in Scheme can be described as a sophisticated goto.  What circumstances warrant the use of goto? When is it best to avoid?  As a followup question: C provides a pair of functions, setjmp and longjmp, that provide the ability to goto not just within the current stack frame but within any of the calling frames. Should these be considered as dangerous as goto? More dangerous?    Dijkstra himself regretted that title, for which he was not responsible. At the end of  (also  .pdf) he wrote:     Finally a short story for the record.   In 1968, the Communications of the ACM   published a text of mine under the   title "The goto statement considered   harmful", which in later years would   be most frequently referenced,   regrettably, however, often by authors   who had seen no more of it than its   title, which became a cornerstone of   my fame by becoming a template: we   would see all sorts of articles under   the title "X considered harmful" for   almost any X, including one titled   "Dijkstra considered harmful". But   what had happened? I had submitted a   paper under the title "A case against   the goto statement", which, in order   to speed up its publication, the   editor had changed into a "letter to   the Editor", and in the process he had   given it a new title of his own   invention! The editor was Niklaus   Wirth.   A well thought out classic paper about this topic, to be matched to that of Dijkstra, is , by Donald E. Knuth. Reading both helps to reestablish context and a non-dogmatic understanding of the subject. In this paper, Dijkstra's opinion on this case is reported and is even more strong:     Donald E. Knuth: I believe that by presenting such a   view I am not in fact disagreeing   sharply with Dijkstra's ideas, since   he recently wrote the following:   "Please don't fall into the trap of   believing that I am terribly   dogmatical about [the go to   statement]. I have the uncomfortable   feeling that others are making a   religion out of it, as if the   conceptual problems of programming   could be solved by a single trick, by   a simple form of coding discipline!" I'm trying to include a tabu inside a new definition of an environment but it fails if the postamble (enddef) of the new environment includes tabu's contents, so cells. With tabular or tabular* works. The error is:   ! Missing number, treated as zero. \tabu@0.H5   The MWE:  \documentclass{article} \usepackage{tabu} \newenvironment{testt} {\begin{tabu} to \textwidth{cccc}  11 &amp; 12 &amp; 13 &amp; 14 \\  21 &amp; 22 &amp; 23 &amp; 24 \\} {  41 &amp; 42 &amp; 43 &amp; 44 \end{tabu} }  \begin{document}  \begin{testt}  31 &amp; 32 &amp; 33 &amp; 34 \\ \end{testt} \end{document}   How to solve this? How to get time difference in minutes in PHP How to calculate minute difference between two date-times in PHP?