DB2 graphic  QMF Version 8

UNQ. -- Eliminate duplicate rows

UNQ. eliminates duplicate rows from query results. If your example table contains two or more P. rows, QMF deletes duplicate rows from the query result by default. However, if your table has only one P. row, and you want to prevent duplicate rows, use UNQ. under the table name in the row with the P. operator.

When you run this query:

Q.ORG | DEPTNUMB | DEPTNAME | MANAGER | DIVISION | LOCATION |
------+----------+----------+---------+----------+----------|
UNQ.  |          |          |         | P.       |          |

QMF produces this result:

DIVISION
----------
CORPORATE
EASTERN
MIDWEST
WESTERN


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