PERCENTILE-DISC（X）函数与CUME-DIST相反，它在每一个分组中检查累积分布的数值，直到找到大于或等于X的值。
PERCENTILE-CONT（X）函数与PERCENT-RANK（）相反，在每一个分组中检查百分比排名的值，直到
找到大于或等于X的值。
下面我们来看个例子获取百分点大于等于0.6的销售总量：
SQL> SELECT
2 PERCENTILE_CONT(0.6) WITHIN GROUP (ORDER BY SUM(amount) DESC) AS percentile_cont,
3 PERCENTILE_DISC(0.6) WITHIN GROUP (ORDER BY SUM(amount) DESC) AS percentile_disc
4 FROM all_sales
5 WHERE year=2003
6 GROUP BY prd_type_id;
PERCENTILE_CONT PERCENTILE_DISC
--------------- ---------------
417855.11 402751.16
以上是网友的笔记，以下是我的试验：
select percentile_cont(0.1) within group (order by sum(amount) desc) as percentile_cont,
percentile_disc(0.1) within group (order by sum(amount) desc) percentile_disc
from all_sales
group by prd_type_id;
PERCENTILE_CONT PERCENTILE_DISC
--------------- ---------------
1435184.13 1889959.57
Nnd 暂时不知道用在何处？
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271063/viewspace-912072/ ，如需转载，请注明出处，否则将追究法律责任。
