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 3990Post New IAS SQL PLSQL Interview Questions
What is different between webusercontrol and in webcustomcontrol?
What can I do with my m&s sparks points?
In a switch statement, what will happen if a break statement is omitted?
How do I view an exe file?
How would you check if MySQLdb is installed?
What are the validation controls available in ASP.NET?
How to read the parameter value from the url in apex?
WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?
Difference between contribute Vs Edit and Read Vs Edit?
Tell me about a project you completed recently that was ahead of schedule.
Describe immunoglobulin (ig) e.
wat is meant by frontend and backend testing
What is the difference between concurrency and parallelism?
Just a one miniute topics in English?
How are the exceptions handled in sql server programming?