更新时间:2023-02-05 09:28:49
with C as ( select ID, row_number() over(order by DT) as rn from YourTable ) delete C1 from C as C1 inner join C as C2 on C1.rn = C2.rn-1 and C1.ID = C2.ID
SE-Data
在 SQL 查询中查找下一行并仅在前一行匹配时将其删除