如何删除SQL中的重复记录？

您可以使用 ie 删除重复项ROW_NUMBER()：

with duplicates as
(
    select
        *
        ,ROW_NUMBER() OVER (PARTITION BY FirstName, LastName, age ORDER BY FirstName) AS number
    from yourTable
)
delete 
from duplicates
where number > 1

number大于 1 的每一行都是重复的。