write a query to delete similar records in same table
- 13 Answers
- 21374 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
how to fetch alternate records from a table? : Sql dba
What are the different types of joins in sql?
Explain what is sql?
What is sql catalog?
where are cookies actually stored on the hard disk? : Sql dba
Does sqlite need a server?
How much does sql certification cost?
What are character functions in sql?
what is the bond code in materialized view?
What is blind sql injection?
what is a constraint? : Sql dba
How do I start sql profiler?
How to Execute a Package in PL/SQL.?
What is sqlcommand?
Can we use ddl statements in stored procedure?
