Distinct

SELECT DISTINCT <COLUMN>
FROM <TABLE>

Selects only unique values from that table.

If there are multiple columns then its every unique pairing of all values in those 2 columns that occur and the same goes on for every additional column:

SELECT DISTINCT <COLUMN 1>, [COLUMN 2], [...]
FROM <TABLE>