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 表名称