DELETE a
FROM (
SELECT
ROW_NUMBER() OVER (PARTITION BY ID ORDER BY ID) num
FROM XXDownloadData
where Id IS NOT NULL
) a
WHERE num>1
GO
SQL 删除重复数据
DELETE a
FROM (
SELECT
ROW_NUMBER() OVER (PARTITION BY ID ORDER BY ID) num
FROM XXDownloadData
where Id IS NOT NULL
) a
WHERE num>1
GO
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
