List:General Discussion« Previous MessageNext Message »
From:Michael Genereux Date:March 30 2005 10:18pm
Subject:Re: GROUP BY, ORDER BY clauses
View as plain text  
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
<ahabib@stripped> 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/mysql?unsub=1
> 
>
Thread
GROUP BY, ORDER BY clausesAsad Habib30 Mar
  • Re: GROUP BY, ORDER BY clausesSGreen30 Mar
    • Re: GROUP BY, ORDER BY clausesAsad Habib30 Mar
  • Re: GROUP BY, ORDER BY clausesMichael Genereux31 Mar