sql get rows with duplicate values
/* Gets reps */ SELECT fieldA, COUNT(*) FROM tableA GROUP BY fieldA HAVING COUNT(*) > 1 /* Use reps to filter results */ SELECT a.* FROM tableA a JOIN ( SELECT fieldA, COUNT(*) as 'count' FROM tableA GROUP BY fieldA HAVING COUNT(*) > 1 ) b ON a.fieldA = b.fieldA