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
- 14028 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
How can we check the version of Teradata that we are using currently?
What is meant by a dispatcher?
What is oltp?
What is a node in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is meant by a Highest Cost Plan?
What is a sparse index?
How do you determine the number of sessions?
Explain fastload in teradata?
Explain teradata vs. Redshift?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Difference between multiload and tpump?
What are the different softwares used with their functions in teradata?
What is the primary index in teradata?
Why is the case expression used in teradata?
