Sorting the History Records 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
dita:id
B035-2430
Product Category
Teradata Tools and Utilities
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.
    All columns in the active window are presented in the Available Columns list box.
  2. In the Sort dialog, select the column name in the Available Columns list, then click Add.

    By default, the sort direction for this new sort column is ascending. Click or to change the sort order.

  3. To remove a sort column from the list, double-click the column name, or select it and press Delete or click Remove.
    You can also remove all columns from the Sort Keys list by clicking Clear.
  4. After you select the columns by which you want to sort and the direction in which you want to sort, click Sort.
    Sorting history using the Seq (sequence number) column has exactly the same effect as sorting by date and time. However, it is considerably faster.