delete from wm_big where id not in (select minid from (select min(id) as minid from wm_big group by state,sn) b)
delete from 表 where id not in (select minid from (select min(id) as minid from wm_big group by 字段1,字段2) b)
delete from wm_big where id not in (select minid from (select min(id) as minid from wm_big group by state,sn) b)
delete from 表 where id not in (select minid from (select min(id) as minid from wm_big group by 字段1,字段2) b)