SELECT *, COUNT(*) c FROM table GROUP BY column HAVING c > 1;
Advertisements