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
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How is the teradata different from oracle?
What is the basic syntax for teradata select statement?
What is a three-tier data warehouse?
How is MLOAD Client System restarted after execution?
Comment whether bottleneck is an error or not.
What do you mean by teradata intelliflex?
Define views in teradata with syntax.
What is real time and near real time data warehousing?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is bteq utility in teradata?
What is teradata?
What are teradata utilities?
What is the difference between fastload and multiload? Which one is faster?
While creating table my dba has fallback or no fallback in his ddl. What is that?