Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 25438 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivadasan
Sorry for the previous answer....
We can do like this ,
1. First we have to transfer all data from original_table
table to a temporary table .
create table Temp_table as select * from original_table;
2. Delete all record from Original Table....
delete original_table;
3. Now we can write a query by using INSERT and UNION
insert into original_table (select * from temp_table
UNION select * from temp_table);
any issues let me know.....
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does sql stand for?
What do you understand by case manipulation functions?
What are secondary keys?
What are aggregate functions in sql?
What are the qualities of 2nf?
What are sql commands?
Is merge a dml statement?
what is normalization? : Sql dba
What is the difference between pl and sql?
What are the events on which a database trigger can be based?
What is pl/sql table? Why it is used?
What is package in pl sql?
What does desc stand for?
what are the difference between clustered and a non-clustered index? : Sql dba
What are pl sql procedures?
