Order By Deck

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.

To Modify an ORDER BY Clause

1. Right click a column in the [Order By] Deck and pick a different sort order.

2. Left click the the column's sort icon and pick a different sort order [Ascending, Descending, Random or None].

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.