对某一列，位移

对某一列，移位

?

?

a

 select c.vc2areacode,                               c.datbegindate as datbeginfee,                                lead(c.datbegindate,1,null) over (partition by c.vc2areacode,Vc2chargetype  order by c.datbegindate ) next_datbeginfee,                               c.datenddate as datendfee,                               c.numfeeprice,                               c.numfeeguid,                              c.vc2chargetype                          from  ct_feerule@prod2 c                         where  c.numvalidflag = 1                           and numbillcodeguid = 3203                           and nvl( c.datenddate,sysdate+1) > trunc(sysdate)