Why did you quote an unrelated message?
Both GROUP BYs will produce one row for each unique combination of the chosen columns. That is, the contents of the results will be identical.
MySQL automatically orders results by the grouped columns, so the ordering of the resulting rows will differ between the two queries.
Depending on your indexes, one may be faster than the other. Best results should come with a multi-column index on the same columns in the same order as in the GROUP BY.
Michael
Martin Gainty wrote:
My original concept to use group by was GROUP BY(MajorColumnGroupIng...MinorColumnGrouping)
I am trying to be convinced that GROUP BY(Minor..Major) will work just as well
Is there a difference???
thanks,
Martin Gainty
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
