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
- 14284 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / tdguy
update using case option is the best option for this query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between global temporary tables and volatile temporary tables?
What is meant by a Clique?
Explain BYNET.
What are the scenarios in which full table scans occurs?
Steps to create a data model?
What do you mean by parsing?
What are the updated features of teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Difference between stored procedure and macro?
How can you track login parameters of users in teradata?
what is object level locking ? where do appear this type of locking ?
How to identify ppi columns?
What are the primary characteristics of the Teradata.
What is the purpose of joins in teradata and what are the available join types?
What exactly do you know about catching in teradata?
