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
14029 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 is teradata and why it is used?

1018

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

1004

How many codd's rules are satisfied by teradata database?

1051

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

984

In Teradata, how do we Generate Sequence?

983

Explain the advantages of partitioned primary index in a query?

976

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3318

What are different table types used in teradata?

982

What are the different methods ot loading a dimension table? A fact table etc?

980

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1662

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

1030

Where is teradata rdbms used?

1038

Explain fallback in teradata?

987

What are the design features involved in teradata?

977

What are the functions involved in shared information architecture?

1019