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 / apurva kumar
UPDATE table
SET Gender = CASE
WHEN Gender = 'Male' THEN 'Female'
ELSE 'Male'
END
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the updated features of teradata?
What is a dimension table?
What can be achieved by using the teradata rdbms?
any one answer me how they can analyzing the project using data ware housing?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the available primary index types in teradata.
Can we collect statistics on table level?
What do you mean by fastexport in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the difference between fastload and multiload? Which one is faster?
What is meant by a dispatcher?
Describe primary index in teradata?
What are the newly developed features of Teradata?
What is real time and near real time data warehousing?