Remove Duplicates with DISTINCT

SELECT DISTINCT removes duplicate rows from the result. SELECT city FROM customers returns six rows, one per customer; SELECT DISTINCT city keeps only one row for each city. NULL also remains in the result as one row.