Re: Distinct rows
Date: 1999/10/23
Message-ID: <7uteua$b15$1_at_nnrp1.deja.com>#1/1
Chris,
Try group by vendorid
In article <9k_P3.4693$Qo3.96613_at_wbnws01.ne.mediaone.net>,
"Chris Jordan" <mail_at_mailer.com> 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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Oct 23 1999 - 00:00:00 CEST