DB2 graphic QMF Version 8

Side group with no summaries

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

Note:
The column selected for the side group moves to the left of the query results, and groups like data accordingly.

For example, select the Side group with no summaries option, then specify to group data by JOB. The query results will be reformatted so that jobs are listed along the left side of the query results, and data specific to that job is grouped with each job.

Note:
You can drill-down (+) to view detailed data or roll up (-) to view summary data.

Things to note in the example below:

Table 33. Side group with no summaries option
1 2 3 4 5 6
JOB ID NAME DEPT YEARS SALARY
(+) MGR 10 SANDERS 20 7 18357.22
15 SWEENEY 21 10 25000.00
(+) SALES 20 PROVENCAL 20 8 18000.06
202 BAILEY 19 20 30000.00
(-) CLERK 110 NGAN 15 5 12508.20
120 NAUGHTON 38 12954.75
130 MOORE 42 6 10505.90
142 HUME 57 11 14252.75
250 BEAUSSET 63 2 40000.00


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