write sub query for eliminating duplicate rows using
analytical function?
- 3 Answers
- 12290 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
Is sql harder than python?
Can we join 3 tables in sql?
What is delimiter sql?
How to create a menu in sqlplus or pl/sql?
how can you see all indexes defined for a table? : Sql dba
Which is faster truncate or drop?
explain mysql aggregate functions. : Sql dba
How do I count records in sql?
What pl/sql package consists of?
What does data normalization mean?
Which nosql database is best?
What is the difference between a query and a report?
What is normalization? How many normalization forms are there?
How is data stored in sql?
What are the built in functions of sql?
