AdvancedWHERE & Filtering

Find employees with above-median salary

The query

SQL

SELECT first_name, last_name, salary
FROM employees
WHERE salary > (
  SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary)
  FROM employees
  WHERE salary IS NOT NULL
)
ORDER BY salary DESC;

Tested against PostgreSQL 16

Note

“PERCENTILE_CONT(0.5) computes the median. Used as scalar subquery for filtering.

Tables referenced

employees10 cols