日期:2014-05-16 浏览次数:20446 次
select
vc2areacode,datbegindate,
?lead(c.datbegindate,1,null) over (partition by c.vc2areacode,Vc2chargetype? order by c.datbegindate ) next_datbeginfee,
DATENDDATE,NUMFEEPRICE,Vc2chargetype,NUMDIRECT from ct_feerule@prod2 c where rownum<100000 order by vc2areacode,datbegindate,DATENDDATE
?
?
?