如何查询到脏数据

[jetora]

使用GROUP BY和HAVING子句：
SELECT column_name, COUNT(column_name) AS count
FROM table_name
GROUP BY column_name
HAVING count > 1;