1)列出单表中所有重复的记录
原始表记录为:
执行如下SQL:select * from test1 WHERE name in(SELECT name FROM test1 GROUP BY name HAVING COUNT(name) >1)
结果为:
1)列出单表中所有重复的记录
原始表记录为:
执行如下SQL:select * from test1 WHERE name in(SELECT name FROM test1 GROUP BY name HAVING COUNT(name) >1)
结果为: