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 / ankal
update stud set gender=
case gender when'male' then'female'
else 'male' end;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain BYNET.
What is the primary index in teradata?
During the Display time, how is the sequence generated by Teradata?
What are the functions of a teradata dba?
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
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the use of stored procedures in teradata?
Explain the term 'columns' related to relational database management system?
What is database exceptions in teradata?
What is meant by Teradata Gateway?
What do you mean by teradata sql assistant?
What is meant by a Channel Driver?
What are the 5 phases in a multiload utility?
What are the various indexes in teradata? How to use them?
What are the steps involved after the disk manager passes the request?