Finding Distinct Values

Restriction: This topic applies to Windows environments only.

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.