If a single sort specification is identified, the rows are ordered by the values of that sort specification. If more than one sort specification is identified, the rows are ordered by the values of the first indicated sort specification, and then by the values of the second identified sort specification, and so on. You can set the ORDER BY clause for SELECT statements and FULLSELECT statements.
Prerequisite: The SELECT statement must be open in the SQL builder.
To create an ORDER BY clause in a SELECT statement in the SQL builder: