Online Documentation for SQL Manager for DB2

Setting sorting parameters


The Sorting tab allows you to set sorting parameters for the records returned by the query.

 

The working area contains the Output fields list (at the left) which represents all fields of the objects used in the query, 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: Items - Move to Selected Items - Move all to Selected Items - Move to Available Items - Move all to Available.

 

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.

 

Query Builder - Setting sorting parameters