# 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. 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 is commonly used with the MODE function.

## 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.15) WITHIN GROUP (ORDER BY score)
FROM players;

percentile_cont|
---------------+
12.5