查询 分组重复数据，保留最新的数据

--删除重复的数据 保留最新的数据 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