PERCENTILE_DISC

The PERCENTILE_DISC 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. If the selected percentile does not have an exact value, this function returns the closest value beneath the requested percentile.

The PERCENTILE_DISC function is commonly used with the MODE function.

Syntax

The following is the correct syntax for the PERCENTILE_DISC function:

PERCENTILE_DISC(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_DISC function:

SELECT
PERCENTILE_DISC(0.15) WITHIN GROUP (ORDER BY score)
FROM players;

percentile_disc|
---------------+
12