Friday, January 28, 2011

How to find duplicate values in a table

SELECT name,email

FROM users

GROUP BY email

HAVING ( COUNT(email) > 1 )

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)