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 / 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
Explain the teradata primary index mechanics in detail with a diagram.
What is smp and mpp platforms?
How do you do backup and recovery in teradata?
If RDBMS is halted what will you do ?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
how do you manage the production space. what are the proactive methods you can take ?
What interface is used to connect to windows based applications?
What are the different functions included in the server software?
Difference between stored procedure and macro?
How many tables can you join in v2r5?
What are default access rights in teradata?
Explain the most common data types used in teradata?
How to eliminate product joins in a teradata sql query?
Why teradata is used?