Summary - DISTINCT

Write a report query with DISTINCT and COUNT(DISTINCT).

In this group you learned DISTINCT alone, with multiple columns, with COUNT and inside aggregates. Cleaning duplicates is now easy.

SELECT COUNT(DISTINCT city) AS n FROM customers;

This query counts how many distinct cities there are.

COUNT(DISTINCT city) AS n is selected from customers.

Exercise Summary - DISTINCT

Select unique categories from products.

Show example solution

SELECT DISTINCT category
FROM products