Database Toolbox Previous page   Next Page

All or Distinct

After selecting the Fields for a query, select All from Advanced query options to retrieve all occurrences, or select Distinct to limit results to only unique occurrences.

Example Using All and Distinct

Compare the following two query results. For All, the query used the All option. For Distinct, the query used the Distinct option.

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

See Also


Previous page  Advanced Query Options Where Next page

© 1994-2005 The MathWorks, Inc.