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 2460Post 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 scope of static variable in c?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Can you tell me limit of character used for PPC Ads ?
Have you already been placed?
Rate yourself on your learning abilities in terms of fast learner, slow learner, moderate learner?
Could you find this place easily?
Tell me can the size of operator be used to tell the size of an array passed to a function?
If I have put commit in badi implementation class after update, is it allowed? Also if some standard functionality already implemented an update and now i m doing update and if it fails, what will be the impact of commit?
In DAO we are writting sql queries , how it is possible with creating and closing database connections.
How to start hbase services?
What is index, cluster index and nonclustered index?
How many variables are in python?
What is database migration? And how to use it to add insert initial data to database?
What is the difference between rank and dense_rank?
Why powerpoint is called powerpoint?
