Oracle 查询某条数据的前后数据
select * from T_PRODUCT_CATEGORY where cate_id=(select c.p from (select cate_id,lag(cate_id,1,0) over (order by DISPLAYORDER desc) as p from T_PRODUCT_CATEGORY where PRODUCT_MARK='1' and STATUS='1') c where c.cate_id='2387') and PRODUCT_MARK='1' and STATUS='1';--查询当前商品分类排序的前一条 select * from T_PRODUCT_CATEGORY where cate_id=(select c.n from (select cate_id,lead(cate_id,1,0) over (order by DISPLAYORDER desc) as n from T_PRODUCT_CATEGORY where PRODUCT_MARK='1' and STATUS='1') c where c.cate_id='2387') and PRODUCT_MARK='1' and STATUS='1';--查询当前商品分类排序的后一条