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 14087IBM 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 8875Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
6 14058Hello 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 13845Post New Cap Gemini Teradata Interview Questions
What is the difference between decision table and decision tree?
What are the frequency compensation methods?
Type casting and error handling
What is the difference between page control and window control in wpf?
Which tools are available to manage SQL Azure databases and servers?
i) Distinguish between Theodolite and dumpy Level? (Marks-8) ii)Distinguish between Viscous and Turbulent flow? (Marks-8) iii) Distinguish between nominal and design mix? iv) What is standard sand? v) Explain the term plane stress? Vi) Differentiate between principal plane and principal axis? Vii) write short notes on Elastic limit of structural steel? viii) Write short notes on stress concentration? ix) write short notes on "Grading of Sand" ? x) How many grades of concrete are there under standard concrete?
What is the opposite of control z?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How many sites use magento?
What is the query that gets executed and will get the results? In case if we have a large number of rows, how can we know the exact no of rows returned? : sap bobi
How does hdfs give great throughput?
How to eliminate duplicate entries in internal tables?
What are the four essential states of an activity?
What is the use of accessors and mutators in eloquent?
You are a project manager for a telecommunications firm. You're working on a project that entails upgrading technical hardware and equipment. The estimated cost of the hardware and equipment is $1,725,000. You are reviewing products from three different vendors. One of the vendors invites you to lunch. What is the most appropriate response? A. Thank them but let them know this could be a conflict of interest since you haven't made a decision about which vendor you're going to choose. B. Thank them and decline. You know this could be considered personal gain, which could call your integrity into question. C. Thank them and accept. You don't believe there is a conflict of interest or a personal integrity issue. D. Thank them and decline. You believe this could be a conflict of interest on the part of the vendor, and you don't want to encourage that behavior.