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)
子查询中要给别名。不然就会报错
