SQL Language (MOSC)

MOSC Banner

Delete duplicate rows

edited Feb 18, 2010 5:10AM in SQL Language (MOSC) 4 commentsAnswered
Hi,

I need to delete one of the duplicate rows from the table as follows

ID(PK)           Firstname                        Lastname

001               ANDRE                          BAS

002               ANDRE                          BAS

003               CHARLIE                     DAVID

004               CHARLIE                     DAVID

005                 RUSH                            WELL

006                 RUSH                            WELL

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center