/* select unique values */

SELECT  distinct  ssn
from  student;



/* If the column has nulls */

SELECT  distinct  street2
from  address;