SELECT DISTINCT

SELECT DISTINCT column FROM table;

or

SELECT DISTINCT (column) FROM table;

This can be used for this use case:

A table can contain a column that has duplicate values, and you may only want to list the unique/distinct values.