根据某字段数据去重

delete  from employee where id in
(
	select id from 
	(
		select *from employee where identity in (select   identity from employee group by   identity   having count(identity) > 1) 
and id not in (select min(id) from   employee group by identity having count(identity )>1)
	) ids
) ;



delete from
	employee
where
	id not in
(
	select a.id from
	( select min(id) id from   employee group by identity ) as a
)