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