Re: Remove Duplicate Rows without a Primary Key
From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Mon, 27 Oct 2003 17:20:56 -0500
Message-ID: <3528739.1067293256_at_dbforums.com>
Date: Mon, 27 Oct 2003 17:20:56 -0500
Message-ID: <3528739.1067293256_at_dbforums.com>
You can do this:
RENAME FOO TO FOO_BKP; CREATE TABLE FOO AS SELECT DISTINCT * FROM FOO_BKP;
-- Posted via http://dbforums.comReceived on Mon Oct 27 2003 - 23:20:56 CET