1- ROW_NUMBER() over() 实现排名
select a.*,ROW_NUMBER() over(ORDER BY nvl(sal,0) DESC) as "名次" from emp a;
2- 计算百分比函数
ratio_to_report(c_allbalance) over() as c_ratio 计算每行 c_allbalance 占sum(c_allbalance)比例
1- ROW_NUMBER() over() 实现排名
select a.*,ROW_NUMBER() over(ORDER BY nvl(sal,0) DESC) as "名次" from emp a;
2- 计算百分比函数
ratio_to_report(c_allbalance) over() as c_ratio 计算每行 c_allbalance 占sum(c_allbalance)比例