How to exclude duplicate rows from the result set (Enterprise Manager)

To exclude duplicate rows from the result set

1. Ensure nothing is selected; then right-click anywhere in the Query Designer window and select Properties.
2. In the Query tab of the Properties window, select Distinct values.