SQL · Aggregation and grouping

filter clause

Applies a condition to a single aggregate without splitting the query.

sqlRunnable example sql course

Syntax

count(*) filter (where …)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (5), (15), (30))
SELECT count(*) FILTER (WHERE minutes >= 10) AS long_lessons FROM lessons;

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