如何删除重复的条件的行数？

[HQSummer]

现在有一张表结构，如图：

删除两行重复的条件 变成下图：


SQL语句如何删除任意几行的相同数据？

[中国风]

e.g.

--只保留两条重复
DELETE T FROM (SELECT *,ROW_NUMBER()OVER(PARTITION BY SPDM,NUM,CKMC ORDER BY SPDM) AS RN FROM Table1) AS T WHERE RN>=3

[LongRui888]

;with t
as
(
select *,row_number() over(partition by SPDM,NUM,CKMC order by getdate()) rn
from tb
)
delete from t whre rn >1