Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: Skill testing SQL question

Re: Skill testing SQL question

From: Patrick Lanphier <planphier_at_psu.edu>
Date: Thu, 04 Nov 1999 17:34:16 -0500
Message-ID: <382209E8.60588B9@psu.edu>

I would have done.

delete from DUPE_TABLE
where rowid IN (select max(rowid)

                            from DUPE_TABLE
                            group by AA, BB);

Patrick Lanphier

>
Received on Thu Nov 04 1999 - 16:34:16 CST

This message: [ Message body ]
Next message: George Dau: "Re: Hotbackup of Rollback segment and temporary tablespace/datafiles"
Previous message: Shaul: "Recover without redo logs!!!"
In reply to: argosy22_at_my-deja.com: "Skill testing SQL question"
Next in thread: -=< a q u a b u b b l e >=-: "Re: Skill testing SQL question"

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