sql查询出重复数据

Answer 1

SELECT * FROM table_name GROUP BY col_name HAVING COUNT(*) >= 2;