User`s guide

5 Using Visual Query Builder
5-38
The Current clauses field now displays:
StockNumber > 400000 AND
e
In Fields, select StockNumber.
f
In Condition, select Relation.
g
In the drop-down list to the right of Relation, select <.
h
In the field to the right of the drop-down list, enter 500000.
i
Click Apply.
The Current clauses field now displays:
StockNumber > 400000 AND
StockNumber < 500000
8
Click OK.
The WHERE Clauses dialog box closes. The Where field and SQL statement
display the Where Clause you specified.
9
Assign the query results to the MATLAB workspace variable A.
10
Click Execute.
11
To view the results, enter A in the Command Window:
12
Save this query as basic_where.qry.
Grouping Statements
Use the WHERE Clauses dialog box to group query statements. In this example, modify
basic_where.qry to retrieve data where sales in January, February, or March exceed
1500 units, if sales in each month exceed 1000 units.