Skip to main content

SELECT DISTINCT outputs a column's unique values

Here’s how to see every value in a column with SQL:

SELECT DISTINCT column
FROM table_name

I found that helpful today when I wanted to understand the significance of a value I was looking at by comparing it to the alternatives.