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

Explain the meaning of Amp?

1239

What are the steps involved after the disk manager passes the request?

1181

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

1049

Discuss the advantages of using partitioned primary index in a query?

1000

Name the five phases that come under MultiLoad Utility.

1028

How many tables can you join in v2r5?

1116

Difference between inner join and outer join?

1082

Differentiate primary key and partition key?

1032

How do you create tables? Exact syntax, and create profiles, users in teradata?

1088

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

1039

Explain teradata utilities?

1093

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

1102

How do you determine the number of sessions?

1106

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1075

How to Extract data from multiple legacy systems?

1172