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
Differentiate database data and data warehouse data?
What are the different functions performed in development phase?
What is the syntax for case when statement?
Explain the term 'primary key' related to relational database management system?
In Teradata, what is the significance of UPSERT command?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Describe the between keyword in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the various reporting tools in the market?
What are the functions of a teradata dba?
What are the components provided on node?
Difference between inner join and outer join?
Which is more efficient group by or distinct to find duplicates?
What is meant by a Virtual Disk?
How to identify ppi columns?