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
- 14472 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / tdguy
update using case option is the best option for this query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Steps to create a data model?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is the difference between fastload and multiload? Which one is faster?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain Teradata performance tuning and optimization?
What are the various indexes in teradata?
How to run a query in teradata?
What is teradata?
How does hashing happens in teradata?
What is inner join and outer join?
What are the different table types that are supported by teradata?
What happens in a conflict? How do you handle that?
What is meant by a Least Cost Plan?
During the Display time, how is the sequence generated by Teradata?
