select no,
name,
hiredate,
lead(hiredate) over(order by hiredate) lead_hd,
hiredate,
lag(hiredate) over(order by hiredate) lag_hd
from tabname
where no=1;
select no,
name,
hiredate,
lead(hiredate) over(order by hiredate) lead_hd,
hiredate,
lag(hiredate) over(order by hiredate) lag_hd
from tabname
where no=1;