다음글 이전글 오라클 쿼리(oracle next pre query)

select * from
(
    select num, title, 
    lead(title,1,'다음글') over (order by num) next_title,
    lag(title,1,'이전글') over (order by num ) pre_title,
    from Tboard 
) 
where best_code='2'