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 the difference between $message and $$message? : Sql dba

998

What does the argument [or replace] do?

1082

Why do we need databases?

1048

What is the process of debugging?

1070

Differentiate between pl/sql and sql?

1152

What is the usage of the distinct keyword?

1220

Why is sharding used?

998

What is string data type in sql?

1144

How do I filter in sql profiler?

995

what does the t-sql command ident_current does? : Transact sql

982

what is user defined functions? : Sql dba

1035

How to change sql*plus system settings?

1055

What is group function in sql?

1024

What is exception? What are the types of exceptions?

1073

Is sql a backend language?

1096