Re: ques: Removing Duplicates

dean wrote in message <347795B7.45F3_at_logical-approach.com>...
>How would I structure an SQL query that would remove duplicates from an
>oracle database? Thanks.

delete from tname t1
where rowid not in (select

                                max(rowid)
                                from tname t2
                                where t1.key=t2.key);

Yours,

Muli Koppel Received on Sun Nov 23 1997 - 00:00:00 CST