delete from EquipmentData where id in (
SELECT Id FROM (
SELECT *,dense_rank() OVER(PARTITION BY EquipmentId,DataTime ORDER BY id DESC) AS RowNo
FROM dbo.EquipmentData
where [DataTime] between '2021-09-17 00:00:00.000' and '2021-09-18 00:00:00.000'
) Ranked WHERE Ranked.RowNo > 1
)
SqlServer批量删除重复数据
最新推荐文章于 2024-04-12 10:22:31 发布