DISTINCT on one column

List unique values of a single column.

Multi-column DISTINCT

DISTINCT works with multiple columns. Rows are unique by the combination of all columns.

SELECT DISTINCT city, category FROM customers;

This query returns rows unique by the city and category combination.

city, category is selected from customers (DISTINCT removes duplicates).

Each column combination appears once. Order does not matter; the same combination in a different order is also deduplicated.

Select unique city and category combinations from customers.

Show example solution

SELECT DISTINCT city, category
FROM customers

Two-column distinct

SELECT DISTINCT ____
FROM customers;

Show answer

SELECT DISTINCT city, category
FROM customers;