情况一:对一个字段查找重复记录
表数据:
a. 首先根据sample_code字段找到重复记录
SELECT * FROM tb_table WHERE sample_code IN(
SELECT sample_code FROM tb_table GROUP BY sample_code HAVING COUNT(sample_code) > 1
);
- 1
- 2
- 3
表数据:
a. 首先根据sample_code字段找到重复记录
SELECT * FROM tb_table WHERE sample_code IN(
SELECT sample_code FROM tb_table GROUP BY sample_code HAVING COUNT(sample_code) > 1
);