Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24938 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 is data control language (dcl)?
What is sql and db2?
How to process query result in pl/sql?
How to download oracle sql developer?
What is a constraint?
What is the command used to fetch first 5 characters of the string?
What is rename command in sql?
Explain the the delete statements in sql?
Why are cursors used?
What is pl/sql table? Why is it used?
Is pl sql useful?
What is trigger and how to use it in sql?
How can the performance of a trigger be improved?
Does asenumerable execute the query?
What is a native sql query?
