SQL · Aggregate functions

percentile_cont()

Continuous percentile, such as the median. PostgreSQL.

sqlRunnable example sql course

Syntax

percentile_cont(0.5) within group (order by x)

Example

Open in the lab

-- PostgreSQL
-- SELECT percentile_cont(0.5) WITHIN GROUP (ORDER BY minutes) FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.