Queries11 / 14
Up next

Remove duplicate rows

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;
What you're solving

DISTINCT keeps unique values