Based upon your question, it is a simple select distinct
and then an order by
SELECT distinct(Column_Name)
FROM Table_name
ORDER BY Column_Name DESC
Or
SELECT distinct(Column_Name)
FROM Table_name
ORDER BY Column_Name
Depending on the Sort order that you want
4
solved List ocurrences in column – SQL