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 / apurva kumar
UPDATE table
SET Gender = CASE
WHEN Gender = 'Male' THEN 'Female'
ELSE 'Male'
END
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is dimensional modeling?
What's the difference between timestamp (0) and timestamp (6)?
What are normalization, first normal form, second normal form and third normal form?
What is node? How many nodes and amps used in your previous project?
What is the command in bteq to check for session settings ?
Why are oltp database designs not generally a good idea for a data warehouse?
What are the steps to create a data model?
What are default access rights in teradata? What explicit right can be given to a user?
How to identify ppi columns?
Highlight the differences between Primary Key and Primary Index.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
List out teradata data types?
If a Node is busy what are the steps you can take to avoid ?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?