Q+E Version 2.50 Supports the Keyword DISTINCT

 Last reviewed: November 2, 1994
Article ID: Q67509

SUMMARY

Microsoft Q+E supports the keyword DISTINCT when querying SQL Server tables only. Q+E returns the error "SELECT DISTINCT is not supported" if you use DISTINCT with text or dBASE compatible files.

DISTINCT is used to eliminate multiple instances of identical records. DISTINCT is not available as a menu option; however, you can add it to the SQL query text.

MORE INFORMATION

To add the keyword DISTINCT, use the following steps:

  1. Start Q+E.

  2. Open the SQL Server table you want to query.

  3. Choose Select SQL Query.

  4. Insert the word "DISTINCT" (without the quotation marks) just after the word "Select." DISTINCT may be capitalized or entered in lowercase.

  5. Choose OK.

For example:

Original Query

   SELECT last_name, first_name, hire_date
   FROM janitors

After Modification

   SELECT DISTINCT last_name, first_name, hire_date
   FROM janitors

KBCategory: kbother
KBSubcategory:



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.