delete 表
from 表 a left join(
select dmzm=min(dmzm)
from 表
where dmzm between '0001' and '1999'
or dmzm between '2000' and '4999'
or dmzm between '5000' and '7999'
or dmzm between '8000' and '10000'
group by dmmc
)b on a.dmzm=b.dmzm
where b.dmzm is null