DELETE t
FROM
(SELECT *,ROW_NUMBER() OVER(PARTITION BY Period
,LegalEntity
,ino_id
,BUZEI ORDER BY Period) AS Row FROM tbl_journal
) AS t
WHERE Row>1
FROM
(SELECT *,ROW_NUMBER() OVER(PARTITION BY Period
,LegalEntity
,ino_id
,BUZEI ORDER BY Period) AS Row FROM tbl_journal
) AS t
WHERE Row>1
现假设留主键最小的那一条DELETE T
FROM(
SELECT *
,ROW_NUMBER()OVER(PARTITION BY Period,LegalEntity,ino_id,BUZEI ORDER BY 主键)RN
FROM tbl_journal
)T WHERE RN>1主键换成你的主键