去重sql

DELETE FROM REPORTS_TASKS
WHERE EXISTS
(
SELECT * FROM (
SELECT MAX(ID) ID,
draft,go,IN_PROGRESS,DISCIPLINE,PROJECT_ID
FROM REPORTS_TASKS
where year_week='2021WK20'
GROUP BY draft,go,IN_PROGRESS,DISCIPLINE,PROJECT_ID
HAVING COUNT(1)>1 ) T
WHERE REPORTS_TASKS.draft=T.draft
AND REPORTS_TASKS.IN_PROGRESS=T.IN_PROGRESS
AND REPORTS_TASKS.go=T.go
AND REPORTS_TASKS.DISCIPLINE=T.DISCIPLINE
AND REPORTS_TASKS.ID=T.ID--如果上面使用MIN函数，这里就要改成>
and REPORTS_TASKS.YEAR_WEEK='2021WK15'
and REPORTS_TASKS.PROJECT_ID=T.PROJECT_ID
)