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).
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).