Re: ques: Removing Duplicates

dean wrote:
>
> How would I structure an SQL query that would remove duplicates from an
> oracle database? Thanks.

Dean,

If the rows are truly complete duplicates, you can brute-force a solution by:

  create table new_table as select distinct * from old_table;

Then replace the old_table with the new_table.

If only some of the columns are duplicate, I'd like to know what solution you come up with, since I've needed the same solution.

Yours,  

Geoff Houck
systems hk
2hksys_at_teleport.com [Delete the "2" to respond] http://www.teleport.com/~hksys Received on Sun Nov 23 1997 - 00:00:00 CST