GROUP BY x THEN BY Y??

[o2designs]

Is it possible in MySQL to group by more than one item.

Eg. GROUP BY x THEN BY Y

what i want is to perform the GROUP BY function and then to group those results by another perameter??

Any ideas
Regards

Alex S

[cgraz]

I'm not sure if you can do it with GROUP BY (or what you're trying to accomplish), but you can do

SELECT * FROM your_table ORDER BY x, y

You can always try

SELECT * FROM your_table GROUP BY x, y

and see if it works. But I'm guessing ORDER BY should do what you're looking for.

Cgraz