Posted By

fugue on 05/05/10

Tagged

6 people have marked this snippet as a favorite

/ Published in: MySQL

SELECT id, COUNT(*) as n
FROM my_table
GROUP BY id
HAVING n >1;

Comment:

You need to login to post a comment.