SQL · Aggregate functions

count distinct

Counts unique non-null values.

sqlRunnable example sql course

Syntax

count(distinct expression)

Example

Open in the lab

WITH lessons(course) AS (VALUES ('HTML'), ('CSS'), ('HTML'))
SELECT count(DISTINCT course) AS courses FROM lessons;

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