delete from emp where rowid>any(select min(rowid) from emp a where a.

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / dinesh mohan upadhyay

Answer Posted / dinesh mohan upadhyay

delete from emp
where rowid>any(select min(rowid) from emp a where
a.col1=col1)

Is This Answer Correct ?

15 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Does a primary key have to be a number?

931

How does pl sql work?

925

How to convert comma separated string to array in pl/sql?

1132

How do we accept inputs from user during runtime?

1017

what is the use of double ampersand (&&) in sql queries?

1134

What does over partition by mean in sql?

933

What is case function?

997

What is the difference between the implicit and explicit cursors?

1009

What is the main reason behind using an index?

980

what is a field in a database ? : Sql dba

1006

Is sql easier than java?

956

What is nvarchar in sql?

892

how can you see all indexes defined for a table? : Sql dba

957

What is #table in sql?

1017

what is an extent ? : Sql dba

1036