Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14268 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / tdguy
update using case option is the best option for this query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is teradata? What are some primary characteristics of teradata?
How can bottlenecks be identified?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Is multi insert ansi standard?
How many sessions of MAX is PE capable of handling at a particular time?
Explain the new features of teradata?
how can we analyze the locks ?
How do you do backup and recovery in teradata?
How do you see a ddl for an existing table?
Describe primary index in teradata. And what are the available primary index types?
How to view every column and the columns contained in indexes in teradata?
Explain fastload in teradata?
What is the basic syntax for teradata select statement?
How to Extract data from multiple legacy systems?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
