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
- 12165 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
In the Primary Index, what is the score of AMPs that are actively involved?
What is a level of granularity of a fact table?
How to eliminate product joins in a teradata sql query?
How do you create tables? Exact syntax, and create profiles, users in teradata?
If RDBMS is halted what will you do ?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is a dimension table?
What can be achieved by using the teradata rdbms?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the steps to create a data model?
What are the frequently used data types in teradata?
How to identify ppi columns?
List out all forms of LOCKS that are available in Teradata.
What are the uses of client software involved in teradata?
What are the main components of teradata system?
