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
- IAS PHP Interview Questions (1)
- IAS DB Development Interview Questions (1) IAS SQL PLSQL Interview Questions (1)
- IAS SAP FI-CO (Financial Accounting & Controlling) Interview Questions (1)
- IAS General Science Interview Questions (1)
- IAS Electrical Engineering Interview Questions (1)
- IAS Electronics Communications Interview Questions (1)
- IAS Accounting General Interview Questions (2)
- IAS UPSC Political Science Interview Questions (1)
- IAS UPSC History Interview Questions (1)
- IAS UPSC General Studies Interview Questions (7)
- IAS UPSC AllOther Interview Questions (1)
- IAS SSC History Interview Questions (1)
- IAS SSC Political Science Interview Questions (1)
- IAS SSC Geography Interview Questions (1)
- IAS RRB Interview Questions (1)
- IAS NDA Interview Questions (1)
- IAS Group I Interview Questions (1)
- IAS Group II History Interview Questions (1)
- IAS APPSC AllOther Interview Questions (3)
- IAS General Knowledge_Current Affairs Interview Questions (27)
- IAS Everything Else AllOther Interview Questions (1)
- IAS English Interview Questions (1)
- IAS CAT Interview Questions (1)
- IAS ICET Interview Questions (2)
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.
