EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

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

 

 


See also:

Setting criteria

Setting output fields

Setting grouping criteria