PERCENTILE_DISC_LC
Returns the percentile value using a low-cardinality optimized algorithm.
Analyze Syntax
func.percentile_disc_lc(0.5)
Analyze Examples
func.percentile_disc_lc(0.5)
┌───────┐
│ 72000 │
└───────┘
SQL Syntax
PERCENTILE_DISC_LC(0.5)
SQL Examples
SELECT PERCENTILE_DISC_LC(0.5) WITHIN GROUP (ORDER BY salary) FROM employees;
┌───────┐
│ 72000 │
└───────┘