Just keep in mind that the ORDER BY will require MySQL to take the full resultset and reorder it in a temporary table. MySQL has extended the GROUP BY clause as of version 3.23.34 so that you can also specify ASC and DESC after columns named in the clause.
On Wed, 30 Mar 2005 10:53:38 -0500 (EST), Asad Habib <[EMAIL PROTECTED]> wrote: > Does MySQL 4.1 support the use of GROUP BY and ORDER BY used in > conjunction with one another? I have tried to execute several queries > with both these clauses but the result set I get is different from what I > expect. My queries read as follows: > > SELECT *, *, * FROM * > WHERE * > GROUP BY * ORDER BY * > > Also, does GROUP BY only work on fields that are strings (i.e. > CHAR, VARCHAR, TEXT, etc.). Thanks in advance. > > - Asad > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]