Selecting and grouping datas in a column

this sql lists all the datas in a column removed duplicated ones

SELECT DISTINCT COLUMN_NAME FROM TABLE_NAME ORDER BY COLUMN_NAME