取当前记录的上一条和下一条,一个sql 搞定,不用多次查询或者分页组合
select * from (
select rec_id ,
lead(rec_id) over(order by rec_id) next_id,
lag(rec_id) over(order by rec_id) prev_id
from core_news_information_cn
)
where rec_id = 123456
取当前记录的上一条和下一条,一个sql 搞定,不用多次查询或者分页组合
select * from (
select rec_id ,
lead(rec_id) over(order by rec_id) next_id,
lag(rec_id) over(order by rec_id) prev_id
from core_news_information_cn
)
where rec_id = 123456