delete from table name where rowid not in(select max(rowid) from group by

write sub query for eliminating duplicate rows using
analytical function?

Question Posted / korimantu

3 Answers
13008 Views
Metric Stream, I also Faced
E-Mail Answers

Answer Posted / korimantu

delete from table name where rowid not in(select max(rowid)
from group by last_name);

or

delete from table name where rowid>(select min(rowid) from
where a.last_name=b.last_name);

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are three advantages to using sql?

1024

What is the difference between cross join and natural join?

1024

What are pl/sql cursor exceptions?

1110

How to add, remove, modify users using sql?

1039

what is recursive stored procedure? : Sql dba

989

State few characteristics of pl/sql?

971

Can a primary key be a foreign key?

1023

What are functions in sql?

962

what are the advantages a stored procedure? : Sql dba

978

Is sql harder than python?

1110

What is a join?

1072

What is the importance of sqlcode and sqlerrm?

1356

Why do we go for stored procedures?

1062

what is myisam? : Sql dba

1087

How to set up sql*plus output format in oracle?

1039