删除数据库中重复的记录,留下重复记录第一条记录。
select * from nj_applicant_info a where id <> (
select min(id) from nj_applicant_info t
group by id_card
having count(*)>2 and a.id_card=t.id_card
)
order by a.id_card;
删除数据库中重复的记录,留下重复记录第一条记录。
select * from nj_applicant_info a where id <> (
select min(id) from nj_applicant_info t
group by id_card
having count(*)>2 and a.id_card=t.id_card
)
order by a.id_card;