Question { 4688 }

There is a table which contains all the employee details,
unfortunately there is mistake occured while entering the
data.
ex:
-------------------------------
empid empname gender address
-------------------------------
1 abcd f address1
2 defg m address2
3 ghth m address3
4 jkil f address4
write a update query that will change gender 'm' to 'f'
and 'f' to 'm'

Answer

It isn't possible to me to write a single query.You can first assign another value like 'a' to one of two values.Then assign your required value to the other

"update table set gender='f' where gender='m'"

"update table set gender='m' where gender='a'"