删除mssql中的重复数据

DELETE T
FROM
(
SELECT *
, DupRank = ROW_NUMBER() OVER (
PARTITION BY datacol
ORDER BY (SELECT NULL)
)
FROM datatable
) AS T
WHERE DupRank > 1

posted @ 2023-09-27 17:43  吾心依旧  阅读(30)  评论(0)    收藏  举报