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.
HIRE | NOHIRE | ||||
---|---|---|---|---|---|
TEMPID | INTDATE | MANAGER | TEMPID | INTDATE | MANAGER |
410 | 2002-02-02 | JACOBS | |||
460 | 2002-10-01 | MALVICHI | |||
475 | 2002-12-02 | HJORDIS |