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 14098IBM 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 8879Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
6 14060Hello 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 12462I 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 13852Post New Cap Gemini Teradata Interview Questions
Please explain a Representative Personal Account.
Hi I am Rathnam, How To Remove the duplicates with out using remove duplicate stage in the datastage
Why SQL Agent is used?
How to measure the insulation resistance for printed circuit boards?
Explain the operation of 1φ sinusoidal ac voltage controller?
What is the need of filtering ideal response of filters and actual response of filters? What is sampling theorem? What is impulse response?
What software do you need to run a cucumber web test cases?
tell me something about aix? what is unix and Aix? tell me the difference? what is special in AIX while compare to other servers? why you have chosen AIx?
How To see all the tables from a database of mysql server.
Can you explain how does the people soft enterprise portal work with 8.1x and 8.4 applications?
What olap capabilities do I have within a microstrategy report services document?
How to execute a function in postgresql?
How many types of closures are there in swift?
What do you understand by cursor? Mention the different types of cursor?
Can we call a batch apex program in apex trigger ?