SELECT COUNT (DISTINCT column-name) FROM table-name
SELECT DISTINCT column1, column1, ..... FROM TABLE /*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/