write a query to delete similar records in same table
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 is a nested table in word?
What is t sql used for?
What is java sql package?
Explain what is a database?
What are the methods of filing?
How do I view a view in sql?
How do you drop a trigger?
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?
What is aggregate function in sql?
How many rows can sqlite handle?
What is foreign key in sql with example?
Give the order of sql select?
Who developed sql?
Is primary key a clustered index?
How many types of cursors supported in pl/sql?