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
12977 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 'mysqldump'? : Sql dba

1105

What is a field in a database?

1059

What is percent sign in sql?

1280

Can we create clustered index without primary key?

959

Does sql view stored data?

949

What program will open a mdb file?

958

What are the datatypes available in pl/sql ?

1096

what is the difference between primary key and unique key? : Sql dba

1031

how to create a new view in mysql? : Sql dba

927

Does sap use sql?

977

What is where clause in sql?

1031

What is the difference between pl and sql?

1089

What is bitemporal narrowing?

1298

What is pl/sql table? Why it is used?

1030

What are the ddl commands?

1005