Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 25125 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
How can you fetch first 5 characters of the string?
What is scalar function?
What are schema-level triggers?
How do we accept inputs from user during runtime?
What is sql partition function?
What type of join is sql join?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Show the cursor attributes of pl/sql.
What does over partition by mean in sql?
What is a data definition language?
What is mutating table error?
Can sql developer connect to db2?
When sql appeared?
Is sql injection illegal?
What is foreign key and example?
