Re: ques: Removing Duplicates

From: Richard Spee <caecilia_at_pi.net>
Date: 1997/11/23
Message-ID: <01bcf80e$aae07a80$3ccadc91@default>#1/1

You can use the rowid.
For example:

delete from <table> t1
where exists (select 'x' from <table> t2

                    where t2.<column> = t1.<column>  (do this for all the
columns)
                    and t2.rowid > t1.rowid)

I did not check this sql-statement, but I think the message must be clear

Joseph S. Testa <jtesta_at_scioto.net> wrote in article <3477F28F.F399A478_at_scioto.net>...
> dean wrote:
>
> > How would I structure an SQL query that would remove duplicates from an
> > oracle database? Thanks.
>
> take a look on my web page, the oracle script link, there is one with
> commonly asked sqlplus question and "1" way to get rid of duplicates.
>
> joe
>
> --
> Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
> (home)
> Vice-President Ohio Oracle Users Group,
> See the Oracle FAQ at http://www.orafaq.org
> Try http://web.scioto.net/jtesta that is also the place to find the FREE,
> drop column script
> ICQ UIN: 2832230(&oracle, home).
>
>
>
Received on Sun Nov 23 1997 - 00:00:00 CST