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 Answers
- 12094 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / kumar amit ranjan
UPDATE stud SET gender ='Z' WHERE gender ='F';
UPDATE studmaster SET gender ='F' WHERE gender ='M';
UPDATE studmaster SET gender ='M' WHERE gender ='Z';
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Write a program to show the parser component used in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
Highlight a few of the advantages that ETL tools have over Teradata.
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What do you mean by parsing?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
How can bottlenecks be identified?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is teradata? Also, list out some of the primary characteristics of teradata.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the different design perspectives used in teradata?
What do you mean by fastexport in teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What type of indexing mechanism do we need to use for a typical data warehouse?
