id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
6 14272IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 9012Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
6 14241Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
4 12603I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
4 13994Post New Cap Gemini Teradata Interview Questions
Explain the use of SN.exe
Explain how do I verify oma is functioning?
What is the difference between simple and facilitated diffusion?
Mac stands for?
Explain the fresh water cooling system.
A car's starter motor draws a current of 100 A at 12,0 V when starting the engine. The mechanical power required to turn the engine is 960 W. At what rate is energy from the battery converted to non-mechanical forms of energy?
Explain profitability group ratios.
Explain how to export mappings to the production environment?
What are ajax controls?
What are white spaces in java?
What are the drupal version release dates?
How do you limit memory usage for commands?
What is the difference between a web server and an application server?
Is there any Edit method in ADO Data Access method?
What is call back method?