16.20 - Sorting an Answerset Using Full Sort - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
Full sort allows sorting by data in multiple columns.
  1. Do one of the following:
    • Click .
    • Right-click in the Answerset window, then select Sort.
    • Select Edit > Sort.
    In the Sort Answerset dialog, all columns in the active window are presented in the Available Columns list box.
  2. Select the column name in the Available Columns list box, or use the up or down arrow keys to highlight the column name and press Enter or click Add.

    This moves the column name to the Sort Keys list box.

    By default, the sort direction for this new sort column is ascending.

    If you click a column in the Sort Keys list box, or select the item using the arrow keys or mouse and press Enter, it reverses to descending sort order.

  3. To remove a sort column from the list, double-click the column name, or select it and press the Delete key or click Remove.
    You can also remove all columns from the Sort Keys list by pressing Clear.
  4. After you select the columns by which you want to sort and the direction in which you want to sort, click Sort.