select fdate 日期,total 金额,tax 税额,
sum(total) over (order by fdate) 累计金额,sum(tax) over (order by fdate) 累计税额,
sum(total) over (partition by yymm order by fdate) 本月累计金额,
sum(tax) over (partition by yymm order by fdate) 本月累计税额,yymm
from (select fildate fdate,to_char(fildate,'yyyy-mm') yymm,sum(total) total,sum(tax) tax from stkin t group by fildate)
select fdate 日期,total 金额,tax 税额,
sum(total) over (order by fdate,yymm) 累计金额,sum(tax) over (order by fdate,yymm) 累计税额,
sum(total) over (partition by yymm order by fdate,yymm) 本月累计金额,sum(tax) over (partition by yymm order by fdate,yymm) 本月累计税额,
sum(total) over () 累计金额,
) 占比,
) 月占比,yymm
from (select fildate fdate,to_char(fildate,'yyyy-mm') yymm,sum(total) total,sum(tax) tax from stkin t group by fildate)
order by fdate,yymm;
注1：partition by 表示分组
注2：在"... from emp;"后面不要加order by 子句，使用的分析函数的(partition by yymm order by fdade,yymm)里已经排序的语句了，如果再在句尾添加排序子句，一致倒罢了，不一致，结果就令人费劲了.
2.利用 lag(),lead() 取上下n条记录取值
例1：
select fdate 日期,total 金额,tax 税额,
lag(total,,null) over(order by fdate) 上1条记录金额,
lead(total,,null) over(order by fdate) 下1条记录金额,yymm
from (
select fildate fdate,to_char(fildate,'yyyy-mm') yymm,sum(total) total,sum(tax) tax from stkin t
group by fildate
) order by fdate,yymm;
-->
