SQL删除重复的数据，只保留一条

delete from 表名 where id not in( select min([id]) from 表名 group by [重复字段])

例：

delete from Sell_cardinfo where id not in( select min([id]) from Sell_cardinfo group by [nullah_num])