update using case option is the best option for this query.

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 / tdguy

6 Answers
14030 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

Please Help Members By Posting Answers For Below Questions

how do you manage the production space. what are the proactive methods you can take ?

1884

Difference between star and snowflake schemas?

1056

How do you verify a complicated sql?

1014

How will you solve the problem that occurs during update?

991

Explain parsing engine in teradata?

1026

What is meant by a node?

995

How does hashing happens in teradata?

1020

When tpump is used instead of multiload?

1045

Did you write stored procedures in teradata?

1060

What are the available primary index types in teradata.

979

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4322

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2097

Highlight the advantages of PPI(Partition Primary Index).

1010

What is a node in teradata?

942

What are the functions of a Parser?

1034