What is DISTINCT?

Remove duplicate rows with DISTINCT.

With DISTINCT you remove duplicate rows from a result. It goes right after SELECT.

SELECT DISTINCT city FROM customers;

This query lists the unique cities in the customer table.

city is selected from customers (DISTINCT removes duplicates).

What is DISTINCT? — details

DISTINCT applies to all columns; it deduplicates whole rows, not a single column. Duplicate rows appear once.

Select unique cities from customers.

Show example solution

SELECT DISTINCT city
FROM customers

Deduplicate

SELECT ____ city FROM customers;

Show answer

SELECT DISTINCT city FROM customers;