Eliminating duplicate rows
Use the DISTINCT keyword to eliminate duplicate rows from a report.
The following query displays each department in which some employee is a salesperson. Even if a department has more than one salesperson, QMF displays the department number only once on the report.
SELECT DISTINCT DEPT FROM Q.STAFF WHERE JOB = 'SALES' ORDER BY DEPT