mysql重复字段查询/删除

查询某个字段重复的数据

Select * From 表 Where 字段 In (Select 字段 From 表 Group By 字段 Having Count(*)>1)

删除重复的数据

DELETE
FROM
	表
WHERE
	主键 NOT IN (
		SELECT
			dt.minno
		FROM
			(
				SELECT
					MIN(主键) AS minno
				FROM
					表
				GROUP BY
					字段
			) dt
	)

dt----表的缩写

minmo----MIN(主键)的缩写