delete a
from
[table] a
where
(select count(distinct *) from [table] where num<=a.num)
!=(select count(*) from [table] where num=a.num and number<=a.number)
from
[table] a
where
(select count(distinct *) from [table] where num<=a.num)
!=(select count(*) from [table] where num=a.num and number<=a.number)
0204
0206
0289
0290
(最后的要求是num 和license 都不能有重复的,但是都不能被漏掉或者删掉)