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 4090Post New IAS SQL PLSQL Interview Questions
What is doctype used for in html?
Which type of salary is the best in the sales industry – a fixed one or a salary based on incentives?
Explain what is output redirection?
Mention what are the maximum number of dimensions in info cubes?
Explain what are magic tables in sql server?
What do you mean by an execution plan? Why is it used?
What is limit state method and working stress method and ultimate method
How do you start a startup?
What are the four types of J2EE modules?
What is action in google analytics?
how can i reduce sparking without stepdowning the voltage
How do I clear terminal command history?
Where is asp cache located on iis 6.0?
From the following find out a. Profit Volume ratio b. Break even point c. Sales for 40% P/V Ratio d. Margin of safety from the sales Rs 3,00,000 e. Net profit from the sales of Rs 3,00,000 f. Required sales for the new profit of Rs 70,000 g. Required sales for the net profit of Rs 70,,000 after tax, the corporate income tax being 40% h. Additional sales required to convert an increase of Rs 3000 p.a. in the sales manager salary Sale 2,00,000 Variable Overheads 1,50,000 Profit 50000 Fixed overheads 15000 Net profit 35000 Sl No Heads of Account Debit Rs Credit Rs 1 Drawing and Capital 750 15,000 2 Stock as on 01.01.2009 69720 3 Bills Receivable and bills payable 1000 1180 4 Returns 300 320 5 Purchases and Sales 4500 8300 6 Wages 70 7 Discount 30 8 Salaries 200 9 Canara Bank Shares 3000 10 Insurance 120 11 Building 3000 12 Furniture 700 13 Debtors and Creditors 600 1300 14 Cash in Hand 470 15 Overdraft at bank 900
How do I decide which is the best technology to solve my vibration isolation problem?