分析函數lead()over(),lag()over()

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;