DB2 graphic QMF Version 8

Top group with no summaries

Select a column, then select Results--> Grouping and Aggregation--> Top group with no summaries to:

For example, select the Top group with no summaries option, then specify to group data by DISP (Disposition). The query results will be reformatted so that the DISP column (HIRE or NO HIRE) spans the other columns in the result set.

Table 31. Top group with no summaries option
HIRE NOHIRE
TEMPID INTDATE MANAGER TEMPID INTDATE MANAGER
410 2002-02-02 JACOBS
460 2002-10-01 MALVICHI
475 2002-12-02 HJORDIS


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