Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Distinct rows
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 - 18:04:43 CDT