Re: Delete Duplicate rows from a table
From: <catherine_devlin_at_purpleturtle.com>
Date: 21 Jun 2001 15:43:35 GMT
Message-ID: <9gt4n7$r37$1_at_news.netmar.com>
Date: 21 Jun 2001 15:43:35 GMT
Message-ID: <9gt4n7$r37$1_at_news.netmar.com>
This may not be more efficient than your ROWID method, but...
CREATE TABLE table2 AS
SELECT DISTINCT *
FROM table1;
TRUNCATE TABLE table1;
INSERT INTO table1
SELECT * FROM table2;
DROP TABLE table2;
Good luck!
- Catherine
http://profiles.yahoo.com/arcticturtle
In article <a7b8a58b.0106120820.590b0983_at_posting.google.com>, SATYA PAL
<spgangwar_at_yahoo.com> writes:
>Hi There,
>
>I have a frequent requirement to delete the duplicate rows from a
>table. I know one method using the RowID to delete the duplicate from
>the table.
>
>Is there any best mechanism to delete duplicate rows from the table.
>
>Thanks in advance.
>
>
>Regards
>Satya
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net