Sorting Your Output

You can specify the order in which you want the output sorted. In this example, you use the query from the last example and change the ordering sequence of the columns in the Output window. From the SQL QUERY COLUMNS window, select ViewOrder By.

Select BEGDATE from the Available Columns list. Select the right arrow to move the column to the Order By Columns list. By default, columns are sorted in ascending order, so the abbreviation ASC appears next to the column name in the Order By Columns list. Select BEGDATE ASC and Descending Order to change the ordering sequence.

Select Salary and JOBCODE, and move them to the Order By Columns list.

Select Salary ASC from the Order By Columns list and select Move Before. The Move Columns window appears.

Select BEGDATE and OK. The ORDER BY COLUMNS window appears with Salary first in the Order By Columns list.

Select OK to return to the SQL QUERY COLUMNS window.

Select ViewWhere Conditions for Subset.

The WHERE EXPRESSION window appears. Select Undo four times, until only SALARY LT $18,000 is displayed.

Select OK.

To run your query and view the output in the Output window, select ToolsRun QueryRun Immediate.