MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario descargar pdf (Pagina 273)

100

101

Refine Results Using Query Criteria and Rules

4-23

specifying your query criteria. You can add more rows for these options in the SQL

Criteria panel by clicking +. You can remove a row by clicking -.

• If you select one table in the Database Browser pane, the available options for the

first query condition are WHERE and ORDER BY.

• If you select two tables in the Database Browser pane, the available options for the

first query condition are:

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

• WHERE

• ORDER BY

• AND

• OR

• Press Enter or Tab to apply a condition for a row. The first (leftmost) column

contains query options that produce semantically correct SQL statements for each

subsequent condition that you add. For example, the leftmost column of an applied

condition contains an ORDER BY option. If you click + to add a query option in a new

row, the ORDER BY option can follow only another ORDER BY.

A Join option can follow only another JOIN or WHERE. A JOIN option cannot

follow a WHERE or ORDER BY option.

• When defining a query line for any conditions other than a JOIN, the line does not

take effect until you apply it. When you apply a condition, the software removes all

preceding and succeeding conditions that you did not apply from the SQL Criteria

panel. Similarly, if you click - to remove a query line, if you have applied that query

line, all succeeding conditions are removed. If you have not yet applied the query line,

the software removes only that line from the SQL Criteria panel.

• When using a WHERE SQL statement with a mathematical operator, to match a

string, include the string value in ' ' to apply the condition. If you use the LIKE or

NOT LIKE SQL operator to match a string, the software adds the ' ' to the string

value.

1 2 ... 268 269 270 271 272 273 274 275 276 277 278 ... 683 684

Comentarios a estos manuales

Sin comentarios

MATLAB DATABASE TOOLBOX RELEASE NOTES Guía de usuario Pagina 273

Comentarios a estos manuales

Relacionado con productos y manuales para Software MATLAB DATABASE TOOLBOX RELEASE NOTES