Why doesn't the following work:
mysql> CREATE TABLE dog(id integer, breed char(20),
age integer, weight integer)
;
mysql> SELECT breed, MIN(age)
-> FROM dog
-> GROUP BY breed
-> ORDER BY MIN(age);
ERROR 1111: Invalid use of group function
but this does
mysql> SELECT breed, MIN(age) AS minage
-> FROM dog
-> GROUP BY breed
-> ORDER BY minage;
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
