1、简单的分组和统计方法
SELECT
ydxm,
COUNT(ydxm)
FROM
YW_JSYDBPTZ
GROUP BY ydxm
HAVING COUNT(ydxm) >= 1;
2、自去重法-取最小id
delete from YW_JSYDBPTZ
where ydxm in (select ydxm from YW_JSYDBPTZ group by ydxm having COUNT(*)>1) and
ID not in (select MIN(ID) from YW_JSYDBPTZ group by ydxm )