且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在 SQL 查询中查找下一行并仅在前一行匹配时将其删除

更新时间: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