PERCENTILE_DISC
Returns the smallest value whose cumulative distribution is >= the specified percentile.
Analyze Syntax
func.percentile_disc(0.5)
Analyze Examples
func.percentile_disc(0.5)
┌───────┐
│ 72000 │
└───────┘
SQL Syntax
PERCENTILE_DISC(0.5)
SQL Examples
SELECT PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY salary) FROM employees;
┌───────┐
│ 72000 │
└───────┘