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
1 4019Post New IAS SQL PLSQL Interview Questions
What programs are slowing down my pc?
What is actioncontext?
Explain either/left/right design pattern in scala?
How would you handle negative feedback from angry clients?
What is the and operator in c#?
What are different types of transactions in ar? : oracle accounts receivable
What is Partition table in Hive?
Which shell is the best?
What is book profit? How it was calculated
What is servo motor and what are the applications of servo motor?
What is kararch effect?
Compare the working principle of gas turbine of capacity more than 10megaW, diesel generator and wind turbine
State what is roll-up summary field?
What is arraylist e?
What are the different Annotations in Salesforce and tell me with examples?