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 11971IBM 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 7633Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
6 12338Hello 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 10966I 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 12240Post New Cap Gemini Teradata Interview Questions
What is data formatting in excel?
Can you think of a logic behind the game minesweeper.
What are the different execute methods of Ado.Net?
What are the process steps in split document subcommand?
To what extent until my team is self-adequate in developing automated processes?
What does entry and exit criteria mean in a project?
How to do eager loading in hibernate?
How do I add multiple rows to a table in excel?
What is the correct syntax of mail() function in php?
Distinguish among erase, erase permanent, erase selective and erase all?
Explain about thinhtime and thicktime function?
Write a program to find duplicate number from array in minimum time complexity.
How do I edit system32 in windows 7?
What are respectively some remarkable functions of myosin, cd4, albumin, keratin, immunoglobulin, reverse transcriptase, hemoglobin, and insulin?
How to encrypt a string?