SQL · Aggregate functions

mode()

The most frequent value in a group. PostgreSQL.

sqlRunnable example sql course

Syntax

mode() within group (order by x)

Example

Open in the lab

-- PostgreSQL
-- SELECT mode() WITHIN GROUP (ORDER BY course) FROM lessons;

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