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 3639Post 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)
Is wordpress secure for ecommerce?
What happens to hard link when file is deleted?
Which tool is used to combine images?
hi to all.... what is the treatment for Work-In-Progress in Tally...please answer for it as early as possible... thanks & regards
Explain about column name and getter method?
Explain how save rerecord in the database?
What if I do not provide the string array as the argument to the method?
List the advantages and disadvantages of user control an custom control?
What is entity framework firstordefault?
What are your strengths and weaknesses? Where do you see yourself 5 years down the line?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
Do hackers use mac or pc?
What helped you sail through hurdles and crack one of the finest jobs?
What is the difference between a view and a stored procedure?
How to select all paragraph elements whose lang attribute contains values that are exactly "en", or begin with "en-"?
