Distinct Values Example

Assume your company has three departments and you query the Employees table to return department numbers. If you do not select Distinct Values, your query may return duplicate department numbers, one for each row (employee) in the table.

DEPTNO 
20
30
30
20
30
30
10
20
10
10

If you select Distinct Values, however, your query will return only those departments that are distinctly different. In this example, the query would return:

DEPTNO 
10
20
30