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 14465IBM 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 9103Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
6 14392Hello 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 12730I 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 14130Post New Cap Gemini Teradata Interview Questions
That Dimension isn’t Having its own Dimension Table?
What are the options of drill through ?
Why are ics so cheap?
What is getlevel0()? What is the use of %subrec and %selectall functions?
We are planning to implement employee interaction centre (eic). We can do it either in crm or erp. What is your advice?
What is the difference between client and server database cursors?
The foundations are placed below ground level, to increase?
How to create master details relationship between existing records?
How vpn is used in the corporate world?
Which algorithm in ‘unification and lifting’ takes two sentences and returns a unifier?
What are the main components of MapReduce Job?
How to Add Static Routes?
Tell something about BRICS Summit?
What configuration files are used in struts?
Define a tree?