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 are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1122

Can we write dml inside a function in sql server?

937

What can you do with pl sql?

1088

How do I truncate a word?

1076

How many aggregate functions are available there in sql?

977

What has stored procedures in sql?

1055

what is text? : Sql dba

1065

What is the use of pl/sql table?

1057

How do I use google cloud in sql?

1080

What is recursive join in sql?

1001

Is sql difficult?

1148

How many unique keys can a table have?

1006

What is the use of index in hive?

998

What is the difference between sql and t sql?

1024

What are actual parameters and formal parameters?

1099