Returns an approximate value for the specified percentile based on the range of numbers returned by the expression.
For example, if you run
APPROX_PERCENTILE with a specified
<percent> of .75 on a column with 2,000 numbers, and the function returned
655, then this would indicate that 75% of the 2,000 numbers in the column are less than 655.
The number returned is not necessarily in the original range of numbers.
| ||A valid expression, such as a column name, that evaluates to numeric values.|
| ||A constant real number greater than or equal to 0.0 and less than 1. For example, |
APPROX_PERCENTILE, we’ll use the example table
number_test as created below. This provides a range of numbers between 1 and 100.
CREATE DIMENSION TABLE IF NOT EXISTS number_test ( First_name TEXT ); INSERT INTO number_test VALUES (1), (100), (55), (16), (48), (86), (33), (22);
The example below shows
APPROX_PERCENTILE of 50% of the number range in
SELECT APPROX_PERCENTILE(num, 0.5) FROM number_test;
The example below shows an
APPROX_PERCENTILE of 25%.
SELECT APPROX_PERCENTILE(num, 0.25) FROM number_test;