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]

Reply via email to