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 4017Post New IAS SQL PLSQL Interview Questions
What does nth child mean in css?
Explain reversal of documents in sap : fi- general ledger accounting
What is microsoft excel?
What are the points that must be kept in mind during forging design?
What is ‘important’ declaration used in css?
Which operator can be used to change the value of the operand or change the state of the condition?
What is package manager in UiPath?
What is jpa and spring data jpa?
How do I find my static ip address to open?
How can I load data from a text file into a table?
What do you mean by get_instance in codeigniter?
How do I install android on my phone?
Who is the author of angular js?
What advantages does DBMS have over traditional file systems?
Define tool Manage Statistics in SQL Server 2000 query ?