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
What is a level of granularity of a fact table?
Which is faster fastload or multiload?
What are the commands to make a new table, change a table and remove a table in teradata?
What is logical data model?
Can we collect statistics on multiple columns?
What is the syntax for case when statement?
What is smp and mpp platforms?
How can we check the version of Teradata that we are using currently?
if collect stats but it show low confidence why?
What is the use of virtual processor connectivity in teradata?
Explain vproc in teradata?
how do you manage the production space. what are the proactive methods you can take ?
Why is the case expression used in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is upsert statement in teradata?