專題文章
時(shí)長:00:00更新時(shí)間:2020-11-09 15:25:04
利用Oracle分析函數(shù)LAG求時(shí)間段內(nèi)的本期、同比、環(huán)比值:with time_dim as (select add_months(add_months(date'2013-7-1',-12),(rownum-1)) dim_month from dual connect by level =months_between(date'2014-1-1',date'2012-7-1')+1)select t.dim_month, t.c_count, nvl(t.ly_count,0) ly_count, nvl(t.lm_count,
查看詳情