Eliminating Duplicate Query Rows

*  To eliminate duplicate query rows, select Distinct Values on the Query Builder - Fields page.

    For 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 returns only those departments that are distinctly different.

    DEPTNO 
10
20
30