write a query to delete similar records in different tables
with same structure
Answer Posted / umadevi
example
delete from emp where deptno in (select deptno from dept
where emp.deptno=dept.deptno);
Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How do I remove duplicates in two columns?
Does oracle roll back the transaction on an error?
How is use pl and sql?
what are different types of keys in sql?
What are sql functions? Describe in brief different types of sql functions?
How many columns should be in an index?
What is union and union all keyword in sql?
Mention what is the use of function "module procedure" in pl/sql?
How to run sql*plus commands in sql developer?
what is the use of friend function? : Sql dba
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
Explain 3 basic parts of a trigger.
What is a dynamic query?
How is data stored on a disk?
What is set transaction?