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-09-15 23:05:46 发布