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

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1217

What is logical data model?

1260

What are the different table types that are supported by teradata?

1052

Explain the term 'columns' related to relational database management system?

1124

Different phases of multiload?

1067

How to Extract data from multiple legacy systems?

1176

what are the day to day activities of teradata DBA ?

5865

What are tpump utility limitations?

1180

What is the purpose of upsert command?

1266

Highlight all the modes that are present under Confidence Level.

1015

What is database exceptions in teradata?

1002

What is real time and near real time data warehousing?

1164

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

906

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

2004

Describe the set operators in teradata.

1050