Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in different tables
with same structure
- 4 Answers
- 9385 Views
- I also Faced
- E-Mail Answers
Answer Posted / senthil
This done by Co-related sub-query:- based upon ROWID
uniqness this deletes the duplicate rows.
Delete from emp x where ROWID != (Select MIN(ROWID) from
emp y where y.empno = x.empno);
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is a pl/sql block?
what is sql? : Sql dba
how to do backup entire database? : Transact sql
How exception handling is done in advance pl/sql?
What plvcmt and plvrb does in pl/sql?
What does varchar include?
How delete a row in sql?
what does myisamchk do? : Sql dba
What do you mean by stored procedures?
What is cross join sql?
What is sqlservr exe?
What is benefit of creating memory optimized table?
Mention what are the benefits of pl/sql packages?
What is pls integer?
Can I join the same table twice?
