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
- 14027 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ankal
update stud set gender=
case gender when'male' then'female'
else 'male' end;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the command in bteq to check for session settings ?
Mention a few of the ETL tools that come under Teradata.
What is teradata? Also, list out some of the primary characteristics of teradata.
What is called partitioned primary index (ppi)?
Differentiate database data and data warehouse data?
What is meant by a Parsing Engine?
What interface is used to connect to windows based applications?
What are the different functions performed in development phase?
List the logical and conditional operators that are used with teradata along with their meanings?
What is meant by a Clique?
what is object level locking ? where do appear this type of locking ?
What is the opening step in basic teradata query script?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
How many tables can you join in v2r5?
What's the difference between timestamp (0) and timestamp (6)?
