- Index

< Previous |  | Next >

## percentile

percentile — aggregate function to return value closest to the specified percentile rank

## SYNOPSIS

`percentile (T `column`, double `pct`)`

## DESCRIPTION

This function returns the value of the specified column with percentile rank equal to the specified `pct` value. If there is no value at exactly `pct` percentile, then the value with the greatest percentile less than `pct` is returned. The data type of the specified `column` (and of the corresponding returned value) must be one of the comparable types in the expression language, as listed on the Data Types page.

## SEE ALSO

This LiveView aggregate function is based on the percentile aggregate function in the StreamBase expression language.