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
- 12093 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
I am not sure whether decode will work in teradata 12.0 but case statement can be used.
update stud set gender =
case gender
when 'male' then 'female'
when 'female' then 'male'
end;
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
What is bteq script in teradata?
What are the main components of teradata system?
What are the enhanced features in teradata v2r5 and v2r6?
What is the multi-insert?
Highlight a few of the advantages that ETL tools have over Teradata.
In Teradata, how do we Generate Sequence?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
In the Primary Index, what is the score of AMPs that are actively involved?
What is the meaning of Caching in Teradata?
What happens when a node suffers a downfall?
What are the various indexes in teradata? How to use them?
What is meant by a Parsing Engine?
How to load specific no.of records using bteq, or fastload,or multiload
How can we check the version of Teradata that we are using currently?
Explain fallback in teradata?
