When more than one sort specification is identified, the rows are ordered by the values of the first indicated sort specification, then by the values of the second identified sort specification, and so on.
You cannot use an ORDER BY clause on a SELECT statement within the FULLSELECT statement. The ORDER BY clause applies to the final result set from the FULLSELECT statement. You can sort on either a single column or multiple columns.
To sort on columns in a FULLSELECT statement that have the same ordinal value but are in different subordinate SELECT statements, the columns must have the same name. If the columns have different names in their corresponding subordinate SELECT statements, you must assign the same alias to each of the columns.
To create a ORDER BY clause for a multiple-column sort in a FULLSELECT statement in the SQL builder: