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???
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 the use of having index on table?
What are the different table types that are supported by teradata?
Explain the term 'primary key' related to relational database management system?
What is the difference between fastload and multiload?
What is bteq utility in teradata?
What is logical data model?
What is meant by Teradata Gateway?
What is the maximum number of dml can be coded in a multiload script?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Can we collect statistics on multiple columns?
Explain and compare pros and cons of start schemas?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How to Extract data from multiple legacy systems?
What is the basic syntax for teradata select statement?
If RDBMS is halted what will you do ?