PERCENTILE_CONT

The PERCENTILE_CONT function returns the value located in the selected percentile of a specified column. The required input is a number between 0 and 1 that represents the wanted percentile and the column containing the wanted percentile. If the selected percentile does not have an exact value, the PERCENTILE_CONT function extrapolates a value estimated from the existing values.

The PERCENTILE_CONT function returns an extrapolated value closest to the values in the requested percentile. If you want to see the closest value in your data to the requested percentile, use PERCENTILE DISC.

Syntax

The following is the correct syntax for the PERCENTILE_CONT function:

PERCENTILE_CONT(double) WITHIN GROUP (ORDER BY <column>)

Example

The example in this section is based on the players table below:

Player_Name	Team	Score
T_Tock	Blue	12
N_Stein	Blue	23
F_Dirk	Blue	45
Y_Hyung	Blue	19
A_Rodrick	Blue	37
R_Evans	Red	52
C_Johnston	Red	43
K_Stoll	Red	27
J_Loftus	Red	8
L_Ellis	Red	13
G_Elroy	Red	31

The following is an example of the PERCENTILE_CONT function:

SELECT
PERCENTILE_CONT(0.18) WITHIN GROUP (ORDER BY score)
FROM players;

percentile_cont|
---------------+
12.8

Note

The output value is an extrapolation of the halfway point between the values.