select f_cdxs,min(value) from
(select f_cdxs,abs(f_sl-lead(f_sl,1,9999999) over(partition by f_cdxs order by f_rq desc)) value from dm_dwjd where f_wzyy is not null order by f_rq desc)
where rownum<6
group by f_cdxs
(select f_cdxs,abs(f_sl-lead(f_sl,1,9999999) over(partition by f_cdxs order by f_rq desc)) value from dm_dwjd where f_wzyy is not null order by f_rq desc)
where rownum<6
group by f_cdxs
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货