连续百分率：返回一个对应于排序中指定分数的值

• 复制
  复制成功

postgres=# select * from bills where begincity='三明市';                      
 id | goodsdesc | beginunit | begincity |       pubtime       | amount  
----+-----------+-----------+-----------+---------------------+---------
 12 | 建筑设备  | 福建省    | 三明市    | 2015-10-05 07:21:22 | 2022.31
 13 | 设备      | 福建省    | 三明市    | 2015-10-05 11:21:54 | 8771.11
 14 | 普货      | 福建省    | 三明市    | 2015-10-05 15:19:17 | 1316.27
(3 rows)
postgres=# select                                                             
     min(amount),
     PERCENTILE_CONT(0) WITHIN GROUP(order by amount) AS RATE_0 ,
     PERCENTILE_CONT(0.25) WITHIN GROUP(order by amount) AS RATE_25,
     PERCENTILE_CONT(0.5) WITHIN GROUP(order by amount) AS RATE_50,
     PERCENTILE_CONT(0.75) WITHIN GROUP(order by amount) AS RATE_75,
     PERCENTILE_CONT(1) WITHIN GROUP(order by amount) AS RATE_100
from bills
where
     begincity='三明市'
;  
   min   | rate_0  | rate_25 | rate_50 | rate_75 | rate_100 
---------+---------+---------+---------+---------+----------
 1316.27 | 1316.27 | 1669.29 | 2022.31 | 5396.71 |  8771.11
(1 row)
postgres=#