Remove Duplicate Rows without a Primary Key

From: Damien Cobbs <damien.cobbs_at_gd-ais.com>
Date: 27 Oct 2003 08:18:21 -0800
Message-ID: <4c413633.0310270818.a8b0f9e_at_posting.google.com>

Is there a way to remove duplicate rows from a table that does not have a primary key leaving one copy of the row without comparing each column to each other as suggested by the code example below:

delete from foo x
where x.rowid <> (
select min(rowid) from foo y
where y.primary key = x.primary key
)

Any ideas? Received on Mon Oct 27 2003 - 17:18:21 CET

This message: [ Message body ]
Next message: hrishy: "Re: How to implement 'search' similar to Google"
Previous message: LiFo: "how to select all rows where a colums has null"
Next in thread: nobody: "Re: Remove Duplicate Rows without a Primary Key"
Reply: nobody: "Re: Remove Duplicate Rows without a Primary Key"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message