Re: Distinct rows

From: Peter Okhiria <peter.okhiria_at_mci.com>
Date: Fri, 22 Oct 1999 16:09:14 GMT
Message-ID: <38103931.A35CDAE2@mci.com>

use
select distinct vendorid, product, description from vendors where vendorid < 100

Chris Jordan wrote:

> Hi I have a query (select vendorid, product, description from vendors where
> vendorid < 100) that is returning duplicate information, ie.
> VENDORID PRODUCT DESCRIPTION
> 1 Switches RKS
> 1 Switches DDK
> 2 UPS New
>
> What query can I use that displays only one instance of a specifc vendor,
> i.e in the above, only vendorids 1 & 2 are
> displayed for a total of two records(1,switches,RKS) and (2,UPS,New).
>
> Thanks,
> Chris
Received on Fri Oct 22 1999 - 11:09:14 CDT