write a query to delete similar records in same table
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
Why do we need cursors in pl sql?
Why is partition used in sql?
how to shutdown mysql server? : Sql dba
What is multiple columns?
List the ways to get the count of records in a table?
Does truncate need commit?
What is the difference between cross join and natural join?
What are pl sql data types?
Is sql workbench free?
What is pl sql architecture?
What is a primary key called that is made up of more than one field?
How do I make sql search faster?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How do you modify a column in sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?