接上篇sql 排序,排序后,可查出上下条数据。
Row_Number() 函数给表添加了一列序列号且不重复,即可根据当前数据对应的值,找上下条数据。
依旧是上文的例子,如下图,假如要查“工单号为‘order005’的下一条数据”:
实现:
select * from
(select Date 日期,OrderID 工单号,OrderSeq 工单顺序,Row_Number() over(order by OrderSeq) as 实际顺序 from
(
select 'order001' as OrderID,'2018-2-3' as Date, 10 as OrderSeq
union all select 'order002' as OrderID,'2018-2-3' as Date, 20 as OrderSeq
union all select 'order003' as OrderID,'2018-2-5' as Date, 30 as OrderSeq
union all select 'order004' as OrderID,'2018-2-4'