Teradata SQL Assistant can display data rows in the Answerset window in a grouped, sorted order.
-
In the active window, click
.
A Group Bar appears above the spreadsheet. -
Drag the column header you want to group by to the Group Bar.
If you group by a single column, each row in that column displays the column name followed by the column value and the number of rows that have this value in parentheses. To open a group, click on the + symbol at the left of the row.
-
To group by multiple columns, drag the additional column headers to the right of the previous ones on the group bar.
They are connected in descending order.
The top-level group continues to display the column name and data value, but does not display the number of rows that contain that value. The lower-level Group rows display the column number (starting at column zero) followed by the data value for that group. Each header you drag to the Group Bar display a Sort icon to indicate the current sort direction. You can reverse the direction by clicking on this icon.
-
To ungroup the rows, drag the headers back to the spreadsheet header bar, or simply click a second time.