Microsoft SQL Server 使用CTE删除重复的行
示例
员工表：
| ID | FirstName | LastName | Gender | Salary |+------+-----------+----------+--------+--------+
| 1 | Mark | Hastings | Male | 60000 |
| 1 | Mark | Hastings | Male | 60000 |
| 2 | Mary | Lambeth | Female | 30000 |
| 2 | Mary | Lambeth | Female | 30000 |
| 3 | Ben | Hoskins | Male | 70000 |
| 3 | Ben | Hoskins | Male | 70000 |
| 3 | Ben | Hoskins | Male | 70000 |
+------+-----------+----------+--------+--------+
CTE（公用表表达式）：
WITH EmployeesCTE AS(
SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber
FROM Employees
)
DELETE FROM EmployeesCTE WHERE RowNumber > 1
执行结果：
| ID | FirstName | LastName | Gender | Salary |+------+-----------+----------+--------+--------+
| 1 | Mark | Hastings | Male | 60000 |
| 2 | Mary | Lambeth | Female | 30000 |
| 3 | Ben | Hoskins | Male | 70000 |
+------+-----------+----------+--------+--------+
以上是 Microsoft SQL Server 使用CTE删除重复的行 的全部内容， 来源链接： utcz.com/z/343171.html
