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
12941 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 is a join?

1046

What is nested table in pl sql?

1052

What is a primary key example?

942

How do I run sql profiler?

1051

How delete all data from table in sql?

1004

What is sql query optimization?

1090

What is the best partition size for windows 10?

986

What is inner join in sql?

1060

Why self join is used in sql?

963

What is the use of pl/sql table?

1047

What does select count (*) mean in sql?

1005

how many ways to get the current time? : Sql dba

988

Does db2 use sql?

923

What are the ddl commands?

990

What is replication id?

922