MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador descarregar pdf (Página 322)

5 Using Visual Query Builder

February ASC

To specify March as the third sort field and display results in descending order:

In Fields, select March.

For Sort key number, enter 3.

For Sort order, select Descending.

Click Apply.

The Current clauses area now displays:

February ASC

The ORDER BY Clauses dialog box closes. The Order by field and the SQL

statement in VQB display the specified Order By clause.

Assign the query results to the MATLAB workspace variable B.

Click Execute to run the query.

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:

Sem comentários

MATLAB DATABASE TOOLBOX RELEASE NOTES Guia do Utilizador Página 322