delete from bl_mbzd where JGDM='320582106010001' and MBID in (select MBID from BL_MBZD group by MBID having COUNT(MBID)>1)
and ID not in (select min(ID) from bl_mbzd group by MBID having count(ID)>1)
and ID not in (select min(ID) from bl_mbzd group by MBID having count(ID)>1)