Hi, you can use something like this select count(*) as co from ... group by ... order by co DESC limit 0,1
HTH Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ ----- Original Message ----- From: "Hu Qinan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 16:03 Subject: embedded group function > All, > > I tried to use > SELECT MAX(COUNT(*)) > FROM ... > GROUP BY ... > > in MySQL. But an error occured: Invalid use of group function. > > Is it necessary to create a temporary table to store the COUNT(*) results, and then get the MAX from it? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
