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???
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
What is teradata and why it is used?
What are the components used in smp and massively parallel processing (mpp) machines?
How many codd's rules are satisfied by teradata database?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
In Teradata, how do we Generate Sequence?
Explain the advantages of partitioned primary index in a query?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are different table types used in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
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
What are the steps involved after the disk manager passes the request?
Where is teradata rdbms used?
Explain fallback in teradata?
What are the design features involved in teradata?
What are the functions involved in shared information architecture?