SELECT DISTINCT(item) FROM a.table #### SELECT item FROM a.table GROUP BY item