Online Documentation for SQL Query for DB2
Setting sorting parameters
The Sorting tab allows you to set the sorting parameters for the records returned by the query.
The working area contains the Output fields list (at the left) which represents all the output query fields, and the Sorted fields list (at the right) which contains the fields to sort records by.
To move a field from one list to another, drag the selected field or use the Add and Remove buttons.
To change the sorting order for a sorted field, select the field in the Sorted fields list and move it using the Up and Down buttons.
To change the sorting direction, select the field in the Sorted fields list and switch the direction (Ascending, Descending) using the corresponding A..Z/Z..A button.