Re: group by problem
Hi,
It sounds like you don't really want a GROUP BY, but instead an ORDER BY? A GROUP BY will do exactly what you said, reduce the number of rows coming back. I don't entirely follow what you are saying though, so I could be wrong. Can you give an example of a table, and the output that you really want?
Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Subject
Written By
Posted
Re: group by problem
October 15, 2004 02:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.