删除重复行

delete from PWLP_CASE_PENALTY pcp where pcp.case_id in
(
SELECT case_id
FROM PWLP_CASE_PENALTY PWLP
group by pwlp.case_id having count(1)>1
)
and pcp.rowid not in (
SELECT min(PWLP.rowid)
FROM PWLP_CASE_PENALTY PWLP
group by pwlp.case_id having count(1)>1
)