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
Explain BYNET.
When tpump is used instead of multiload?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Explain the advantages of partitioned primary index in a query?
What is inner join and outer join?
What is the difference between fastload and multiload? Which one is faster?
What is smp and mpp platforms?
How does hashing happens in teradata?
What are different table types used in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the various indexes in teradata?
How can we check the version of Teradata that we are using currently?
What does sleep function does in fast load?
What are the functions of a Parser?
What are the main components of teradata system?