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
- 14023 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
Explain the term 'tables' related to relational database management system?
Describe the set operators in teradata.
Describe primary index in teradata. And what are the available primary index types?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is basic teradata query language?
What do you mean by caching in teradata?
What is a dimension table?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is a three-tier data warehouse?
What is the syntax for case when statement?
What are the design features involved in teradata?
How is MLOAD Teradata Server restarted after execution?
What is teradata and why it is used?
What are the functions performed by bynet?
What are the steps involved in the process flow of the sql statement through channel attached system?
