sorry,把order by 列,修改一下
curosr t_sor is
select col,lag(col,1,null) over(order by start_date desc,col) lag_col,lead(col,1,null) over(order by start_date desc,col) lead_col,start_date,end_date,datafields from cd_data order by start_date;
curosr t_sor is
select col,lag(col,1,null) over(order by start_date desc,col) lag_col,lead(col,1,null) over(order by start_date desc,col) lead_col,start_date,end_date,datafields from cd_data order by start_date;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货