Re: Distinct rows

From: <arunjayaram_at_my-deja.com>
Date: Sat, 23 Oct 1999 23:04:43 GMT
Message-ID: <7uteua$b15$1_at_nnrp1.deja.com>

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 Sun Oct 24 1999 - 01:04:43 CEST

This message: [ Message body ]
Next message: -=< a q u a b u b b l e >=-: "Re: Looking for Easy Cheap Query Tool"
Previous message: Eviloneus: "Can someone please answer this question about oracle licensing"
In reply to: Chris Jordan: "Distinct rows"
In reply to Chris Jordan: "Distinct rows"
Next in thread: -=< a q u a b u b b l e >=-: "Re: Looking for Easy Cheap Query Tool"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message