这是我的原始表:
目标表格:
我无法向表中添加新列。
发布于 2019-05-21 04:46:53
您可以使用例如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的每一行都是重复的。
发布于 2019-05-21 04:48:16
您可以使用公用表表达式删除一组重复项中除第一条记录以外的所有记录:
with cte as (
select *, row_number()
over (partition by FirstName, LastName, Age order by FirstName, LastName, Age) as row_number
from tbl
)
delete from cte where row_number <> 1
https://stackoverflow.com/questions/56227919
复制相似问题