PERCENTILE-DISC（X）函数

PERCENTILE-DISC （ X ）函数[@more@]

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博客 ” ，链接：http://blog.itpub.net/271063/viewspace-912072/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/271063/viewspace-912072/