SCOTT用户下的EMP表为例：

select ename,
JOB,
ratio_to_report(SAL) over() as "占所有雇员的百分比",
ratio_to_report(SAL) over(partition by JOB) as "占各部门的百分比"
from EMP ;

下面是不用分析函数实现的方式：

select ename,job,
(sal/sum(sal) over()) as "占所有雇员的百分比",
(sal/sum(sal) over(partition by job)) as "占各部门的百分比"
from emp
group by ename,sal,job
order by 2;

ITPub博客

【分析函数】ratio_to_report分析函数求占比

最新文章