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
- 12092 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 meant by a dispatcher?
How can we check the version of Teradata that we are using currently?
What is the maximum number of dml can be coded in a multiload script?
Explain the term 'primary key' related to relational database management system?
In the Primary Index, what is the score of AMPs that are actively involved?
What is basic teradata query language?
What are the updated features of teradata?
Difference between inner join and outer join?
What is TPD?
Describe the between keyword in teradata?
What is meant by a Least Cost Plan?
Can we collect statistics on multiple columns?
What is difference between user and database in teradata?
What is the function of parser component in teradata?
Explain the term 'tables' related to relational database management system?
