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
- 14480 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 are the various indexes in teradata? Why are they preferred?
Explain the term 'row' related to relational database management system?
If a Node is busy what are the steps you can take to avoid ?
Explain some differences between mpp and smp?
any one answer me how they can analyzing the project using data ware housing?
Highlight a few of the advantages that ETL tools have over Teradata.
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the main components of teradata system?
Which is more efficient group by or distinct to find duplicates?
Highlight the limitations of TPUMP Utility.
How do you determine the number of sessions?
List out teradata data types?
What are the various indexes in teradata? How to use them?
Define views in teradata with syntax.
What is the difference between fastload and multiload? Which one is faster?
