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

[Vivek Pandian <vp25@OIT.GATECH.EDU>]

If your database is ORACLE use ROWID logic.

Vivek

At 10:03 AM 5/15/00 -0400, you wrote:
>Hi group.
>Just was wondering if anyone have done anything like that i am about to
>describe, or can recommend a better method.
>Let say I have a table with > 100,000 numbers of rows, For some rows, there
>are identical information between them. example: Row 5 and 6 have the same
>Vendor_id_doc number, this can happen a few time throughout out the table.
>Which way is better to approach this problem: SQL or SQR and How to code it
>too. I can do this in Excel but it have a rows limits. I can use a bubble
>search method where i can take one row and compare to the next and next till
>i get to the end and repeat again the next time,one more row greater than
>the first. Is this do-able with SQR or SQL?
>Any better suggestion would be appreciate.
>TIA
>Binh