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
- 14474 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 are the newly developed features of Teradata?
What is multi insert?
What does sleep function does in fast load?
Different phases of multiload?
What is bteq script in teradata?
Explain amp in teradata?
How to view every column and the columns contained in indexes in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Can we collect statistics on table level?
What are the available primary index types?
Difference between inner join and outer join?
What are aggregate tables? How do you design them using teradata?
What is meant by a Virtual Disk?
What is teradata? What are some primary characteristics of teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
