Page History
ORDER BY clauses sort the records in the results of a SELECT statement. When a column is dropped inside the [Order By] Deck the column is given a sort order, which is indicated by the large arrow icon at the right side of the column name.
By default, all columns are given ascending order.
...
3. Or right-click to select a Function [AVG, COUNT, COUNT_BIG, MAX, MIN, SUM]
4. Or select [Custom Expression] from the bottom of the [Functions] list to write a Custom Expression
If more than one column is placed in the [Order By] Deck the SQL Pane will reflect its addition. Dragging columns into a new order alters which Order By occurs first.
...