SQL 反复数据的提取与过滤

SQL 重复数据的提取与过滤

提取重复数据

SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) > 1 

过滤重复数据

SELECT * FROM tablename GROUP BY colname HAVING COUNT(*) = 1