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
- 9410 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
How do you use collections in procedure to return the resultset?
What are the methods of filing?
How exception handling is done in advance pl/sql?
Does sql require a server?
What is difference between inner join and cross join?
What is sp_helptext?
What is dynamic query?
What is the difference between function, procedure and package in pl/sql?
what does myisamchk do? : Sql dba
What is relationship? How many types of relationship are there?
What are the events on which a database trigger can be based?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How do I view a procedure in sql?
Explain the structure of pl/sql in brief.
