# 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