Ctrl+K

PERCENTILE_CONT

PERCENTILE_CONT#

Calculates a percentile based on a continuous distribution of the column value. The result is interpolated and might not be equal to any of the specific values in the column.

Syntax#

PERCENTILE_CONT ( numeric_literal )
    WITHIN GROUP ( ORDER BY order_by_expression [ ASC | DESC ] )
    OVER ( [ <partition_by_clause> ] )

Arguments#

numeric_literal

The percentile to compute. The value must range between 0.0 and 1.0.

Return types#

float

Example#

SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY [IntColumn]) OVER() AS [ReturnValuePercentileCont]
  FROM [IntTable]

See Also#

Contents