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