User`s guide

Fine-Tuning Queries Using Advanced Query Options
5-35
8
To retrieve only unique occurrences of data:
a
In Advanced query options, select Distinct.
b
Assign the query results to a MATLAB workspace variable Distinct.
c
Click Execute to run the query.
9
In the Command Window, enter All, Distinct to display the query results:
The value 3000 appears three times in All, but appears only once in Distinct.
Retrieving Data That Meets Specified Criteria
Use basic.qry and the Where field in Advanced query options to retrieve stock
numbers greater than 400000 and less than 500000:
1
Load basic.qry.