UPDATE stud SET gender ='Z' WHERE gender ='F'; UPDATE

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 / kumar amit ranjan

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

Answer Posted / kumar amit ranjan

UPDATE stud SET gender ='Z' WHERE gender ='F';
UPDATE studmaster SET gender ='F' WHERE gender ='M';
UPDATE studmaster SET gender ='M' WHERE gender ='Z';

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the day to day activities of teradata DBA ?

5831

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

2424

Explain the meaning of Amp?

1162

what is object level locking ? where do appear this type of locking ?

3506

How do you define Teradata?

1041

Mention a few of the ETL tools that come under Teradata.

1081

Describe the between keyword in teradata?

1044

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1249

Can we collect statistics on table level?

1044

How will you solve the problem that occurs during update?

1064

What are aggregate tables? How do you design them using teradata?

1178

What is collect statistics?

1008

What are the things to be considered while creating secondary index?

1104

What are the multiload utility limitations?

1069

What is meant by a dispatcher?

1026