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)

子查詢中要給別名。不然就會(huì)報(bào)錯(cuò)