oracle 查询当前记录的上一条记录或下一条记录

上一条

select *

  from cms_article a
 where id = (select c.p
               from (select t.id, lag(t.id, 1, 0) over(order by t.sort) as p
                       from cms_article t) c
              where c.id = '8a3e56b6396630260139663fa32d01e1');

下一条

select a.id,a.title
  from cms_article a
 where id = (select c.p
               from (select t.id, lead(t.id, 1, 0) over(order by t.sort,t.eidt_date) as p
                       from cms_article t ) c
              where c.id = '8a3e56b6396630260139663fa32d01e1');