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
- 14294 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
I am not sure whether decode will work in teradata 12.0 but case statement can be used.
update stud set gender =
case gender
when 'male' then 'female'
when 'female' then 'male'
end;
| Is This Answer Correct ? | 24 Yes | 1 No |
Answer / ankal
update stud set gender=
case gender when'male' then'female'
else 'male' end;
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / tdguy
update using case option is the best option for this query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srinu
update stud set gender= decode(gender,'M','F','F','M')
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / apurva kumar
UPDATE table
SET Gender = CASE
WHEN Gender = 'Male' THEN 'Female'
ELSE 'Male'
END
| Is This Answer Correct ? | 1 Yes | 1 No |
How to eliminate product joins in a teradata sql query?
Difference between Qualify and group
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
What are the scenarios in which full table scans occurs?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is the difference between teradata and oracle?
What is the difference between union and union all in teradata?
Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
what is use of fload loading into set table?
Which is more efficient group by or distinct to find duplicates?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain the term 'foreign key' related to relational database management system?
Teradata 
