17,086
社区成员
发帖
与我相关
我的任务
分享
select startdate,enddate,planratio
from(
select startdate,enddate,planratio,lag(planratio,1)over(partition by planratio order by dt desc) -planratio plg
from dm_loanplanratio
where to_char(enddate,'yyyy') = '2016'
)where plg is null
order by startdate