Looks like no one knows the answer to this question... ----- 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