Database Toolbox    

Retrieving Unique Occurrences

In the Visual Query Builder Advanced query options, select Distinct to limit results to only unique occurrences. Select All to retrieve all occurrences. For example:

  1. Select the Data source; for example, dbtoolboxdemo.
  2. Select the Tables; for example, SalesVolume.
  3. Select the Fields; for example, January.
  4. Run the query to retrieve all occurrences.
    1. In Advanced query options, select All.
    2. Assign a MATLAB workspace variable; for example, All.
    3. Click Execute.
  5. Run the query to retrieve only unique occurrences.
    1. In Advanced query options, select Distinct.
    2. Assign a MATLAB workspace variable, for example, Distinct.
    3. Click Execute.
  6. In the Data area, the Workspace variable size shows 10x1 for All and 8x1 for Distinct.
  7. In the Command Window, type All, Distinct to display the query results.

    The value 3000, appears three times in All, but appears only once in Distinct.


 Fine-Tuning Queries Using Advanced Query Options Retrieving Information That Meets Specified Criteria