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 2514Post New IAS SQL PLSQL Interview Questions
What is the difference between truncate and delete? How would a full table scan behave after?
Differentiate between open sql and native sql.
What are the advantages of iot?
What is a shuffle block in spark?
What is resource in android?
What are the different types of channels used by .net remoting and which is the best one?
What is Linux Shell? What is Shell Script?
How do I find the size of a postgres table?
What is indexing and its types?
What languages does BlackBerry App World support?
What is the content of /etc directory?
Why is flash player needed?
How can the Development and Implementation of the (IoT) be affected by technical Standards?
How do I fix a program that is not responding?
Define Beta.