Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24705 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 the benefits of pl/sql packages?
What are the disadvantages of not performing database normalization?
what tools available for managing mysql server? : Sql dba
What is bulk compiling in pl/sql.?
What is sql injection vulnerability?
How many sql are there?
What is nosql vs sql?
What is procedure explain with example?
which operator is used in query for pattern matching? : Sql dba
How do I kill a query in postgresql?
How do I order columns in sql?
Is natural join and inner join same?
what are the difference between clustered and a non-clustered index? : Sql dba
What are the ddl commands?
Can we use loop in sql?
