最后一个where后是查询重复的字段

 DELETE FROM KPI_SCORE_INFO WHERE RESOURCE_ID not in 
(select RESOURCE_ID from KPI_SCORE_INFO as a where RESOURCE_ID=(
select MIN(RESOURCE_ID) from KPI_SCORE_INFO where PROJECT_ID=a.PROJECT_ID ))

分享到：

赞(3)