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???
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 |
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
Find 2 highest sal from each dept who have completed 5 year in org
what are the roles and responsibilities of teradata DBA ?
how teradata fetches a row from primary index table?
Define views in teradata with syntax.
Hash collision?
Discuss the advantages of using partitioned primary index in a query?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the use of fallback?
What do you mean by ttu in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are the multiload utility limitations?