> Looks like no one knows the answer to this question... =or we don't want to state the obvious/seem rude when saying "RTFM" 7.19 SELECT Syntax "All keywords used must be given in exactly the order shown above. For example, a HAVING clause must come after any GROUP BY clause and before any ORDER BY clause."
=dn > ----- Original Message ----- > From: "Christian Andersson" <[EMAIL PROTECTED]> > To: "MySQL Mailing list" <[EMAIL PROTECTED]> > Sent: Monday, November 12, 2001 10:30 PM > Subject: order by, group by > > > > I asked before, but got no answer, so I ask again, but refrase myself a > > little > > > > Is it possible in myslq to do an order by before an group by? > > as far as I know, the order by will happen after the group by, and sort > all > > the grouped rows(I assume that when grouping it just takes the first found > > unique row), but what I'd really would like to do is sort the results > before > > grouping so that > > I can controle which rows are to be presented back to me... > > > > the only way right now for me is to skip the group by in mysql, and do an > > own group by in the program, but I guess that if > > it is possible to do in mysql it would be faster since there would atleast > > be less to transfer from mysql to my application (java/jdbc based) > > > > > > or are there other tricks I can use to get what I want? > > > > /Christian Andersson > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php