EMS logo

Products Navigation

SQL Query for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Query for Oracle

On-line Documentation

Setting sorting parameters

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


hs3326 - Setting sorting parameters


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.


See also:

Working with Query Builder area

Joining tables

Setting criteria

Setting output fields

Setting grouping criteria

Working with the editor area

Query execution