write a query to delete similar records in same table
- 13 Answers
- 21208 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 a parameter query?
Is sql between inclusive?
What is the difference between instead of trigger and after trigger?
What are different types of statements supported by sql?
Why sql query is slow?
What is sql procedures and functions?
how many triggers are allowed in mysql table? : Sql dba
How to run sql commands in sql*plus?
When are we going to use truncate and delete?
Explain ddl statements in pl/sql?
How does stored procedure reduce network traffic?
Why stored procedure is better than query?
What is crud stand for?
how to convert character strings to numeric values? : Sql dba
How to avoid duplicate records in a query?
