Expression With Order By (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

This function is only available when connected to a Teradata database.

The Expression With Order By SQL element provides a container in which to sort by one or more columns (or expressions). To add a column to the Expression With Order By element, drag it from the Columns selector to the Sort Expressions folder (shown below).

Variable Creation > Input > Variables: SQL Elements pane - Other > Expression With Order By

To specify the sort properties (including “ascending/descending” and “nulls first/nulls last”) for a column (or expression), drag the ASC/DESC Order element onto the column (or expression) underneath the Sort Expressions folder. For more information about the ASC/DESC Order element, see (ASC/DESC Order).