Re: Is this Do-able with SQL or SQR.

[Manoj Gurjar <mgurjar@HOTMAIL.COM>]

it will give the counts, not the actual rows.

may be he wants to have actual rows :
select
<field list>
from table a, table b
where a.doc_number = b.doc_number

! pl see the same table is used with diff table alias

hth,
manoj

>From: "Jamadagni, Rajendra" <rajendra.jamadagni@ESPN.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: Re: Is this Do-able with SQL or SQR.
>Date: Mon, 15 May 2000 10:16:35 -0400
>
>You didn't specify what you needed .... but something like this will
>probably help you ....
>
>select venter_id, doc_number, count(*)
>from your_table
>group by vender_id, doc_number
>having count(*) > 1
>
>this will give you all the rows with the duplicate venter_id / Doc_number
>combo.
>
>HTH
>Raj

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com