CREATE TABLE sale (id INTEGER, region TEXT); INSERT INTO sale VALUES (1, 'North'), (2, 'South'), (3, 'North'), (4, 'East'); -- DISTINCT collapses repeated values to one SELECT DISTINCT region FROM sale ORDER BY region;
DISTINCT keeps unique values