Interested to Buy Any Domain ? << Click Here >> for more details...
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???
- 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
Explain the meaning of Amp?
What are the steps involved after the disk manager passes the request?
What are the different table types that are supported by teradata?
Discuss the advantages of using partitioned primary index in a query?
Name the five phases that come under MultiLoad Utility.
How many tables can you join in v2r5?
Difference between inner join and outer join?
Differentiate primary key and partition key?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain teradata utilities?
What are normalization, first normal form, second normal form and third normal form?
How do you determine the number of sessions?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How to Extract data from multiple legacy systems?
