Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24711 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sivadasan
I think simply we can do like the following..
1. First we have to transfer all data from a table to
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
If any issue let me know....
insert into original_table (select * from temp_table
UNION select * from UNION )
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the types of triggers in sql?
What is db journal file?
What is string join?
What language is oracle sql developer?
What is field delimiter?
Why we use join in sql?
Explain the the update statement in sql?
What is sql rowcount?
What are the different sql commands?
What is flag in sql?
How show all rows in sql?
What is a primary key? Explain
Can we call dml statement in function?
explain the delete statements in sql
What is sql basics?
