在项目中会有要求查询重复的数据
#----------------------查询重复值------------------
#使用两个表来查询出所有重复的数
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 表名称