一个哥们问我取得某条新闻的上一条和下一条怎么写?就写了一个
select pre,id,next from (select lag(id,1,-1) over(order by id asc) pre,id ,lead(id,1,-1) over(order by id asc) next from t_xx) where id='111111'[@more@]
select pre,id,next from (select lag(id,1,-1) over(order by id asc) pre,id ,lead(id,1,-1) over(order by id asc) next from t_xx) where id='111111'[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15247/viewspace-896205/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15247/viewspace-896205/