sqlserver 删除重复数据，保留一条

1.

WITH cte AS (
    SELECT FBase1,ftext,  ROW_NUMBER() OVER(PARTITION BY FBase1,ftext ORDER BY (SELECT 0)) AS rn
    FROM table where fid =1006
)
DELETE FROM cte
WHERE rn > 1;

2.--查询重复数据，确认<br>select * From

 (Select Row_Number() Over(Partition By [Name] order By [ID]) As RowNumber,* From Student)T

 Where T.RowNumber > 1

---删除重复数据

Delete T From

 (Select Row_Number() Over(Partition By [Name] order By [ID]) As RowNumber,* From Student)T

 Where T.RowNumber > 1