write a query to delete similar records in same table
- 13 Answers
- 23066 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / apurva
delete from <tablename> rowid not in (select max(rowid)
from <tablename> group by <col.name where there are
repeating records>);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Describe sql comments?
How do we use distinct statement? What is its use?
What is the mutating table and constraining table?
Which query operators in sql is used for pattern matching?
What is a delimiter in sas?
What is sql stand for?
What is the most restrictive isolation level? : Transact sql
Differentiate pl/sql and sql?
How to prepare for oracle pl sql certification?
Can you sum a count in sql?
How can you tell the difference between an index and a view?
How do rank () and dense_rank () differ?
What is the difference between inner join and left join?
Can we use update in sql function?
What is plpgsql language?
