Select a column, then select Results--> Grouping and Aggregation--> Side group with no summaries to:
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.
Things to note in the example below:
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 |