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 and the column that you want to rank. If the selected percentile does not have an exact value, this function returns the closest value beneath the requested percentile.

The PERCENTILE_DISC function returns an exact value based on the closest values in your data to the requested percentile. If you want to see an extrapolated value in your data closest to the requested percentile, use PERCENTILE CONT.

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