DB2 graphic  QMF Version 8

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


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004