Oracle笔记--lag和lead分析函数

/*语法*/  
lag(exp_str,offset,defval) over()  
Lead(exp_str,offset,defval) over()  
--exp_str要取的列  
--offset取偏移后的第几行数据  

--defval:没有符合条件的默认值 

with x0 as
     (select level l,trunc(sysdate,'yyyy')+level-1 curr_time from dual connect by level<=10),
     x1 as
     (select l,curr_time,
             lag(curr_time,2)over(order by curr_time) pre_time,
             lead(curr_time)over(order by curr_time) next_time  from x0)

     select l ,curr_time,pre_time,next_time from x1