sub-select

console.sql

select questoin_id, question_text, prev, next from
(select t0.questoin_id,t0.question_text,
lag(t0.questoin_id) over (order by t0.questoin_id, t0.questoin_id rows between current row and unbounded following) as prev,
lead(t0.questoin_id) over (order by t0.questoin_id, t0.questoin_id rows between current row and unbounded following) as next
from public.result_question t0 inner join public.question t1
inner join public.scenario_subject t2 on t1.scenario_id = t2.scenario_id
and t1.subject_id = t2.subject_id
on t0.questoin_id = t1.question_id
where t0.event_record_id = 42 order by t0.questoin_id) as tbl
where questoin_id = 33