SELECT field, count( field ) FROM table GROUP BY field HAVING Count( field ) > 1 LIMIT 0 , 30
Thursday, November 13, 2003
Check for, and count duplicate records in MySQL
Subscribe to:
Post Comments (Atom)
SELECT field, count( field ) FROM table GROUP BY field HAVING Count( field ) > 1 LIMIT 0 , 30
No comments:
Post a Comment