sql 查询重复的数据

在项目中会有要求查询重复的数据

#----------------------查询重复值------------------#使用两个表来查询出所有重复的数SELECT g.* FROM  code_test g,code_test e  WHERE g.name=e.name AND g.id<>e.id#显示重复的数据SELECT * FROM code_test WHERE NAME IN (SELECT NAME FROM code_test GROUP BY NAME HAVING COUNT(*)>1)#显示重复的那条记录数、SELECT COUNT(t.name) AS "重复个数",t.* FROM code_test t GROUP BY t.NAME HAVING COUNT(t.NAME)>1

去掉重复的

SELECT DISTINCT 列名称 FROM 表名称