Specify an ORDER BY clause
To specify the ORDER BY clause, do the following:
1. Select the columns you want to include in the ORDER BY clause.
2. Specify the sorting order you want for each column in the ORDER BY clause.
Use the ORDER BY sequence pop-up menu to set the sorting order of a column in the list.
The sorting order can be either ascending or descending. The initial sorting order is ascending.
To set the sorting order to descending, select the column you want to set the sorting order of, then from the ORDER BY sequence pop-up menu, select Descending (DESC).
To set the sorting order to ascending, select the column you want to set the sorting order of, then from the ORDER BY sequence pop-up menu, select Ascending (ASC).
3. Specify the sequence you want the columns to be in the ORDER BY clause.
Use the ORDER BY sequence pop-up menu to move a column in the list.
You can either move a column before another column or after another column.
To move a column before another column, select the column then from the ORDER BY sequence pop-up menu, select Move before and then the column you want the one you selected in the list to be moved before.
To move a column after another column, select the column then from the ORDER BY sequence pop-up menu, select Move after and then the column you want the one you selected in the list to be moved after.
Last modified date: 08/13/2019