右键你要选择的数据库，收缩数据库，然后执行就可以了
with test as(select id=row_number()over(partition by CNBMC order by CNBMC),* from tablename where CNBMC in('BLSH_1000','blsh_1001'))delete test where id=2
