delete from tabname
where Id in
(
select Id from
(
select Id,ChuCheTime,ShouCheTime,RegName,VehicleID,BOdometer,EOdometer,RunOdometer,Speed,ViewRunTime,GpsTime,
row_number() over(partition by VehicleID,GpsTime order by ShouCheTime desc) rownum
from tabname--表名
where ProjectID=90
and GpsTime between '2022-11-01' and '2022-12-31 23:59:59'
)A
where rownum >=2
)
partition by 删除重复数据
于 2023-02-15 17:12:24 首次发布