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)
Sorry for the confusion. In this case I am using the * to denote a field
name instead of the wild card character.
- Asad
On Wed, 30 Mar 2005 [EMAIL PROTECTED] wrote:
> Asad Habib <[EMAIL PROTECTED]> wrote on 03/30/2005 10:53:38 AM:
>
> > Does MySQL 4.1 support the use of GROUP BY and ORDER BY u
Asad Habib <[EMAIL PROTECTED]> wrote on 03/30/2005 10:53:38 AM:
> 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 querie
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 *
A
