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 14112IBM 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 8891Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
6 14083Hello 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 12480I 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 13870Post New Cap Gemini Teradata Interview Questions
EXPLAIN WHY YOU CONSIDER YOURSELF SUITED FOR THIS POSITION:
Explain Default cursor Type and LockEdit type in DAO?
What will cause the size of a stored procedure to grow in sybase?
What are indexes? What are b-trees?
What is a data source file?
How long is a page and a half?
What is the difference between c (check) and u (unmaintained)?
Should patient use mouthwash?
How do I know if executenonquery is successful c#?
What is special function registers (sfr)?
How do I stop microsoft programs from opening on startup windows 7?
What are the several built-in supports in go?
Why left join is used in sql?
What is Rack awareness?
What are the different types of work process?