Delete Duplicate rows from a table

From: SATYA PAL <spgangwar_at_yahoo.com>
Date: 12 Jun 2001 09:20:51 -0700
Message-ID: <a7b8a58b.0106120820.590b0983_at_posting.google.com>

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 Received on Tue Jun 12 2001 - 18:20:51 CEST

This message: [ Message body ]
Next message: Benetnasch: "Oracle & MS Access"
Previous message: Philippe L. Balmanno: "Re: which sql book/video is the best?"
Next in thread: catherine_devlin_at_purpleturtle.com: "Re: Delete Duplicate rows from a table"
Reply: Joseph Kohler: "Re: Delete Duplicate rows from a table"
Reply: Joseph Ovadia: "Re: Delete Duplicate rows from a table"
Reply: catherine_devlin_at_purpleturtle.com: "Re: Delete Duplicate rows from a table"

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

Original text of this message