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 12072IBM 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 7675Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
6 12410Hello 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 11054I 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 12340Post New Cap Gemini Teradata Interview Questions
What is vlc web?
Who can see private posts on wordpress?
How to handle mobile browsers/devices events in AngularJS?
please specify some books name in preparing a bank exam apttirutude questions
What is user exits
What is asynchronous messaging in jms?
What is difference between processes and threads?
Does the hdfs client decide the input split or namenode?
Explain static field and their scope?
What are all needed for Correspondence ( Pre-requisites)?
How do I implement an incremental search in list/dir/combo/file boxes?
Can I connect to the database in automation anywhere?
What is the use of Immediate, Local Window?
What is colorimetry?
who are the stake holders in gathering requirement of a new product