SQL · Reading data

distinct

Removes duplicate result rows. Use it deliberately because it costs sorting or hashing.

sqlRunnable example sql course

Syntax

select distinct column

Example

Open in the lab

WITH lessons(track) AS (VALUES ('web'), ('web'), ('data'))
SELECT DISTINCT track FROM lessons;

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