In Order By Columns field, there are two ways you can enter a column name:
- Enter the name of the column (as in the column name State in the preceding example).
- Enter the number of the column, where 1 represents the first column listed in the Select Columns field. Do not type col before the number.
If you want to sort using a derived column, and the derived column has an alias, you may enter the alias name in the Group By Columns field. If the derived column does not have an alias, enter the number of the column (e.g. 1).