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'
- 2 Answers
- 4668 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
update employeedetails
set gender='m'
where gender='f'
update employeedetails
set gender='f'
where gender='m'
| Is This Answer Correct ? | 2 Yes | 2 No |
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'"
| Is This Answer Correct ? | 1 Yes | 2 No |
what does mean and stack mean in genral programming?
how can i apply validation without using errorprovider in C# windows application
how will you do destructive read and non destructive read in data queue.....
can any method return type may be constructor , or that method name allow
what is inprocess and outprocess in vb
i want to open a helkp file that is txt file on link buttons click
can we retrieve only integer/String type columns from a table,if yes how?
If i have a dataset queried from Sql and I would like to insert the dataset into a specific node in an xml document how do I do this
sample and simple coding where we get?
Why we need new operator in java at the time of object declaration and why not in c++?
I am work in it aompenei
hi i am jyoti i have done sap training in sd and master degree in economics have 2 year exp as enduser in (gdms)and 1 year as sd consultant.as contract basis now what i can do for getting job in it industry
C 
