删除表中身份证重复的数据

delete from blacklist where card_no in(select * from (select card_no from blacklist group by card_no having count(card_no) > 1) aa)

and id not in (select * from (select min(id) from blacklist group by card_no having count(card_no )>1) bb)

子查询中要给别名。不然就会报错