Re: Distinct rows
From: Peter Okhiria <peter.okhiria_at_mci.com>
Date: 1999/10/22
Message-ID: <38103931.A35CDAE2_at_mci.com>#1/1
Date: 1999/10/22
Message-ID: <38103931.A35CDAE2_at_mci.com>#1/1
use
Chris Jordan wrote:
> Hi I have a query (select vendorid, product, description from vendors where
select distinct vendorid, product, description from vendors where
vendorid < 100
> 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 - 00:00:00 CEST