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 4014Post New IAS SQL PLSQL Interview Questions
What are key features of python?
selection of the zener barrier for the hazardeous area zone 0
Which cryptographic algorithm is used in blockchain?
Which type of connector we use in FIFA card?
How do you display a list of all reservations in the system?
how to calculate the steel in 500yard
What is a column chart?
What are the different life cycle commands in ambari?
Explain what are the raw materials used for the precipitation of na2co3 by solvay ammonium process?
What are the classes of java?
What is the meaning of stlc?
what does the rman-08147 warning signify when your environment has a goldengate capture processes configured?
Why is labelling important?
If A Class Is Declared Without Any Access Modifiers, Where May The Class Be Accessed?
What is #name error in excel?