有主键(systemid)的情况下,按创建人(created_by)进行分组查询,对分组后数量大于1(HAVING COUNT(*) > 1) 的数据进行删除。
DELETE FROM tablename WHERE
systemid IN (
SELECT systemid FROM (
SELECT created_by,min(systemid) systemid FROM tablename
GROUP BY created_by
HAVING COUNT(*) > 1
) AS a
)
无主键的情况,待补充