1. 查询重复的单个字段(group by)select 重复字段A, count(*) from 表 group by 重复字段A having count(*) > 1
2. 查询重复的多个字段(group by) select 重复字段A, 重复字段B, count(*) from 表 group by 重复字段A, 重复字段B having count(*) > 1
1. 查询重复的单个字段(group by)select 重复字段A, count(*) from 表 group by 重复字段A having count(*) > 1
2. 查询重复的多个字段(group by) select 重复字段A, 重复字段B, count(*) from 表 group by 重复字段A, 重复字段B having count(*) > 1