Database Toolbox

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

• Group By
• Advanced Query Options
• Visual Query Builder Dialog Box

Advanced Query Options

Where

© 1994-2005 The MathWorks, Inc.