Display column values which occur N times



SELECT id

FROM tbl

GROUP BY id

HAVING COUNT(*) = N;

Change the HAVING condition to >1 to list duplicate values, etc.