[研究]SQL Server尋找或刪除某欄位有重複相同資料僅留一筆
2026-09-11
查詢
WITH CTE AS
(
SELECT *,
ROW_NUMBER() OVER (
PARTITION BY AA
ORDER BY ID
) AS RN
FROM table1
)
SELECT *
FROM CTE
WHERE RN > 1;
|
刪除
WITH CTE AS
(
SELECT *,
ROW_NUMBER() OVER (
PARTITION BY AA
ORDER BY ID
) AS RN
FROM table1
)
DELETE FROM CTE
WHERE RN > 1;
|
(完)
沒有留言:
張貼留言