Hu, > SELECT MAX(COUNT(*))
That makes no sense. COUNT(*) will list the number of rows in your table, whereas MAX(column) will list the hightest value of <column> in your table, like that: mysql> SELECT COUNT(*) FROM t; +----------+ | COUNT(*) | +----------+ | 4 | +----------+ 1 row in set (0.00 sec) mysql> SELECT MAX(i) FROM t; +--------+ | MAX(i) | +--------+ | 8 | +--------+ 1 row in set (0.00 sec) You can use both functions with a GROUP BY clause, too. Further details: http://www.mysql.com/doc/en/Group_by_functions.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
