I have a table like so: ID int val1 int val2 int
I can have multiple records where id is the same. e.g: ID val1 val2 1 1 2 1 1 1 2 2 2 2 1 1 2 2 2 I need to find which id has the most records. Thanks Robert Gehrig Webmaster at www.gdbarri.com e-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]