Sort condition control how to sort the rows that will be included in the query results. Rows can be sorted in ascending (A-Z) or descending (Z-A) order.
If you sort your rows by more than one column, the first column is ordered first, then the second column is ordered within the sort order defined for the first column.
There are several methods by which to specify a sort condition:
Select Query --> Add --> Sort Conditions or click the icon in Sort Conditions list box to open the Sort Conditions dialog box and specify the sort conditions.