Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24551 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 count * in sql?
How is sql used in oracle?
What is an emotional trigger?
what is a field in a database ? : Sql dba
What are crud methods?
How do sql databases work?
Is natural join and inner join same?
What does pl sql developer do?
How to display the current date in sql?
What does select count (*) mean in sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How do I view a procedure in sql?
What is information schema in sql?
Can a primary key be a foreign key?
How do I partition in sql?
