对某一列，移位

 

 

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)