Rheal Software Interview Question: write a sql query to swap the... | Glassdoor.co.in

Interview Question

Software Programmer Interview Andher, Maharashtra

write a sql query to swap the genders i.e. from male to

  female and vice versa ?
Answer

Interview Answer

4 Answers

19

update table_Name set gender=case
when gender='Male' then 'Female'
when gender='Female' then 'Male'
end

Ganesh on 24-Dec-2012
5

thanks..can u please post other question

d on 23-Feb-2014
0

i want list of rheal sql questions...pls help me

sonali on 18-Apr-2016
0

i want list of rheal sql questions...pls help me

sonali on 18-Apr-2016

Add Answers or Comments

To comment on this, Sign In or Sign Up.