User`s guide

5 Using Visual Query Builder
5-44
January ASC
February ASC
7
To specify March as the third sort field and display results in descending order:
a
In Fields, select March.
b
For Sort key number, enter 3.
c
For Sort order, select Descending.
d
Click Apply.
The Current clauses area now displays:
January ASC
February ASC
March DESC
8
Click OK.
The ORDER BY Clauses dialog box closes. The Order by field and the SQL
statement in VQB display the specified Order By clause.
9
Assign the query results to the MATLAB workspace variable B.
10
Click Execute to run the query.
11
To view the results, enter B in the Command Window. Enter A to display the
unordered query results and compare them to B. Your results look as follows: