write a query to delete similar records in same table
- 13 Answers
- 22832 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / swapna
One way is to rename the original table to something else,
and copy the unique records into the original table.
rename 'Table2', 'Table1'
select distinct * into Table2 from Table1
drop table1
| Is This Answer Correct ? | 5 Yes | 13 No |
Post New Answer View All Answers
What are few of the schema objects that are created using PL/SQL?
Is it possible to read/write files to-and-from PL/SQL?
What is mdf ldf and ndf?
What are system versioned tables?
What is online transaction processing (oltp)?
What does the base_object_type column shows in the user.triggers data dictionary view?
Is sql difficult?
Is inner join faster than left join?
What is substitution variable?
What is a mutating table and a constraining table?
What is the difference between left and left outer join?
What are the types of queries in sql?
What is assignment operator in pl sql?
explain primary keys and auto increment fields in mysql : sql dba
Which software is used for pl sql programming?
