Interested to Buy Any Domain ? << Click Here >> for more details...
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???
- 6 Answers
- 14267 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
I am not sure whether decode will work in teradata 12.0 but case statement can be used.
update stud set gender =
case gender
when 'male' then 'female'
when 'female' then 'male'
end;
| Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
what are the uses of fact table and dimension table in banking project?
Can you fastexport a field, which is primary key by putting equality on that key?
What happens in a conflict? How do you handle that?
What are the components used in smp and massively parallel processing (mpp) machines?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Which is faster fastload or multiload?
What are default access rights in teradata?
What does Amp contain and what are all the operations that it performs?
Explain parsing engine in teradata?
What are the advantages of teradata?
Explain BYNET.
How many sessions of MAX is PE capable of handling at a particular time?
What are the different design perspectives used in teradata?
Explain teradata architecture in detail with a diagram.
