CODE EXAMPLE FOR SQL

finding duplicate rows mysql

SELECT varchar_col
FROM table
GROUP BY varchar_col
HAVING COUNT(*) > 1;