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 / kumar amit ranjan
UPDATE stud SET gender ='Z' WHERE gender ='F';
UPDATE studmaster SET gender ='F' WHERE gender ='M';
UPDATE studmaster SET gender ='M' WHERE gender ='Z';
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is spool space?
What are the components used in smp and massively parallel processing (mpp) machines?
Can we collect statistics on table level?
How can we check the version of Teradata that we are using currently?
Why does varchar occupy 2 extra bytes?
Explain teradata utilities?
What is a dimension table?
What happens in a conflict? How do you handle that?
What are the string manipulation operators and functions associated with teradata?
What are the joins in teradata?
What are different table types used in teradata?
In Teradata, how do we Generate Sequence?
Describe primary index in teradata. And what are the available primary index types?
What are the advantages of teradata?