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

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

2182

What is spool space?

1159

What are the components used in smp and massively parallel processing (mpp) machines?

1057

Can we collect statistics on table level?

1036

How can we check the version of Teradata that we are using currently?

1069

Why does varchar occupy 2 extra bytes?

1193

Explain teradata utilities?

1042

What is a dimension table?

1063

What happens in a conflict? How do you handle that?

1047

What are the string manipulation operators and functions associated with teradata?

1092

What are the joins in teradata?

1014

What are different table types used in teradata?

1044

In Teradata, how do we Generate Sequence?

1048

Describe primary index in teradata. And what are the available primary index types?

1004

What are the advantages of teradata?

1017