22,302
社区成员




;with t
as
(
select *,row_number() over(partition by SPDM,NUM,CKMC order by getdate()) rn
from tb
)
delete from t whre rn >1
--只保留两条重复
DELETE T FROM (SELECT *,ROW_NUMBER()OVER(PARTITION BY SPDM,NUM,CKMC ORDER BY SPDM) AS RN FROM Table1) AS T WHERE RN>=3