You can create a computed column using the DISTINCT keyword to try to find all unique values in a column. When the DISTINCT keyword is used (instead of the default ALL), duplicate values are discarded. For example, querying the EMPLOYEE table enter the formula:
DISTINCT lname
and the computed column and resulting query do not show two rows with the LNAME Hurwood.