Re: Duplicate items in a table
From: Alex Ivascu <alex_at_ivascu.com>
Date: Wed, 26 Jun 2002 07:08:02 GMT
Message-ID: <lLdS8.312084$352.33960_at_sccrnsc02>
Date: Wed, 26 Jun 2002 07:08:02 GMT
Message-ID: <lLdS8.312084$352.33960_at_sccrnsc02>
Here's an example. I hope it helps:
select col1 from table1 a
where a.rowid > (select min(b.rowid) from table1 b
where b.col1 = a.col1)
/
Alex Ivascu
"kumu" <forlist2001_at_yahoo.com> wrote in message
news:a44abd39.0206250720.7c0a637f_at_posting.google.com...
> Hello,
>
> Please let me know the script that will print out only duplicate
> records within the table.
>
> I have a table with column1... column n and have to find duplicate
> records whithin column 5 and column 6.
>
> thanks a lot
> Kumu
Received on Wed Jun 26 2002 - 09:08:02 CEST