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 3924Post New IAS SQL PLSQL Interview Questions
How many ways to create table-valued functions?
Explain what is the difference between Web testing and WAP testing?
What are the diifferences between the ms sql server vs mysql?
Is mysql open source?
What are your salary requirements at Subway?
explain what is ado.net entity framework?
Which is fastest linux distro?
What are the different types of fragmentation?
what is one way , two way matching , three way , four way matching ?
How many types of logs are there?
List available types of relationships in laravel eloquent.
How many servers can we create in a single subscription?
What is petrologists?
What is the use of ale?
What does plv msg allows you to do?