mysql查询重复数据

查询重复字段

SELECT * FROM 表 a WHERE (( SELECT COUNT(*) FROM 表 WHERE 字段= a.字段) > 1 
) 
ORDER BY
	字段DESC

 删除重复字段

DELETE 
FROM
	表
WHERE
	字段IN (
	SELECT
		字段
	FROM
	( SELECT 字段FROM 表GROUP BY 字段HAVING Count(*)> 1 ) a 
	)