delete from emp p where rowid<(select max(rowid) from emps where p.ename

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 / venkateswararao

Answer Posted / venkateswararao

delete from emp p where rowid<(select max(rowid) from emps where p.ename=s.ename)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is an escape character in sql?

996

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2181

What does over partition by mean in sql?

933

How do I run a script in sql developer?

908

What is trigger types of trigger?

1013

What are the indexing methods?

1013

How do I run a sql trace?

923

What are the advantages of normalization?

1047

What do you mean by “trigger” in sql?

1030

Which normal form is best?

909

How many types of literals are available in pl sql?

1062

How is pl sql different from sql?

1025

What are all the common sql functions?

983

How many commands are in sql?

1018

What are system versioned tables?

978