按照case_sign 分组,保留ID最小的一行记录
DELETEFROM COURT_CASE_DATAWHERE case_sign IN ( SELECT case_sign FROM ( SELECT case_sign FROM COURT_CASE_DATA GROUP BY case_sign HAVING COUNT(id) > 1 ) AS tab1 )AND id NOT IN ( SELECT id FROM ( SELECT MIN(id) AS id FROM COURT_CASE_DATA GROUP BY case_sign HAVING COUNT(id) > 1 ) AS tab2)