Returns an interpolated value that falls within its value_expression with respect to its sort specification.
The function returns the same data type as the data type of the argument.
Nulls are ignored in the calculation.
Type
PERCENTILE_CONT and PERCENTILE_DISC are aggregate functions.