Simply replace table and column
SELECT COUNT(*), * FROM `table` GROUP BY `column` HAVING COUNT(*) > 1;
SQL SELECT NOT DISTINCT (duplicate values)
Leave a reply
Simply replace table and column
SELECT COUNT(*), * FROM `table` GROUP BY `column` HAVING COUNT(*) > 1;