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 3587Post 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 Speculative Execution in Apache Spark?
I am asked to create Usability testing methodology document, basically listing the Procedures & methodology to/for: a. Entry criteria Exit criteria for usability test b. Deliverables d. Methods of doing Reviews and inspection e. Methods of Reporting f. at which testing phase usability testing is done in v model Is there any sample document/template available on Internet? Any help will be greatly appreciated.
Tell me what steps you take to ensure that the work you delegate is successful?
What is business state machine?
Explain and give me an example of a time when you had to explain some new procedures to your co-workers for quality service delivery, how did you go about it?
What is applet toggle and how many types are there?
Define a way to add hibernate mapping file in hibernate configuration file?
What is difference between into and let keyword in LINQ?
How we can create an array with non-default values?
What is the relation between xhtml and url?
Are you willing to work for long hours, if the project demands that from you?
what is the output of select * from tab?
what is a transition in d3.js?
Suppose that American Express has 1 million card members along with their transaction details. They also have 10,000 restaurants and 1000 food coupons. Suggest a method which can be used to pass the food coupons to users given that some users have already received the food coupons so far.
Explain lifecycle methods.
