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>


You can do this:

RENAME FOO TO FOO_BKP; CREATE TABLE FOO AS SELECT DISTINCT * FROM FOO_BKP;

--
Posted via http://dbforums.com
Received on Mon Oct 27 2003 - 23:20:56 CET

Original text of this message