--删除重复的数据 保留最新的数据
with t as (
select * ,ROW_NUMBER() over( PARTITION by a.DeviceId,a.PhoneNumber order by id desc ) as od
from [dbo].[DeviceContact] a
)
delete from t
where od!= 1
查询 分组重复数据，保留最新的数据
最新推荐文章于 2022-07-24 11:16:40 发布
--删除重复的数据 保留最新的数据
with t as (
select * ,ROW_NUMBER() over( PARTITION by a.DeviceId,a.PhoneNumber order by id desc ) as od
from [dbo].[DeviceContact] a
)
delete from t
where od!= 1
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
1022
