Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.tools -> how can I delete duplicate rows?

how can I delete duplicate rows?

From: Mike Moore <hicamel_at_mail.home.com>
Date: Wed, 23 May 2001 01:22:00 GMT
Message-ID: <YgEO6.26292$%i7.22672421@news1.rdc1.sfba.home.com>

How can I delete duplicate rows from a table and only leave one in the table? Lets assume that all of the columns have identical values.

Thanks,
Mike Received on Tue May 22 2001 - 20:22:00 CDT

This message: [ Message body ]
Next message: Daniel A. Morgan: "Re: how can I delete duplicate rows?"
Previous message: Mark D Powell: "Re: How could I know who fires a trigger ???"
Next in thread: Daniel A. Morgan: "Re: how can I delete duplicate rows?"
Reply: Daniel A. Morgan: "Re: how can I delete duplicate rows?"
Reply: Thomas Kyte: "Re: how can I delete duplicate rows?"
Reply: Ludo Van Helleputte: "Re: how can I delete duplicate rows?"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US