UPDATE table SET Gender = CASE WHEN Gender = '

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???

Question Posted / apurva kumar

6 Answers
14291 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2427

What is dimensional modeling?

1098

What's the difference between timestamp (0) and timestamp (6)?

1202

What are normalization, first normal form, second normal form and third normal form?

1063

What is node? How many nodes and amps used in your previous project?

1116

What is the command in bteq to check for session settings ?

1186

Why are oltp database designs not generally a good idea for a data warehouse?

1062

What are the steps to create a data model?

1070

What are default access rights in teradata? What explicit right can be given to a user?

1117

How to identify ppi columns?

1191

Highlight the differences between Primary Key and Primary Index.

1099

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1051

List out teradata data types?

1021

If a Node is busy what are the steps you can take to avoid ?

2420

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1116