Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5755 Views
- I also Faced
- E-Mail Answers
Answer Posted / shahbaz maqsood
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 |
Post New Answer View All Answers
What binary value will be internally stored for NULL for the type S9(1) COMP 3 in mainframe
in IBM PC -AT.WAT AT REFERS TO?
how do i add a column dynamically in a table by using java application?
When we delete logfiles such as screenshots how does it affect the ldf file? Ive seen huge change while adding screenshots in the ldf file but a very minor one deleting them.Please Explain
what is meant by life cycle of a business
How can we develop a multi-tier application in Java?
what is best way to create a Thread class & why?
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
which worker is involved in all the phases of SDLC?
what is an INI file?
What is Negative testing?
Tips for blog integration by www.esteemwebsolutions.com. Can Any body suggest me to how to make wonderful questions on web integration..
Given an array of size n. It contains numbers in the range 1 to n. Each number is present at least once except for 1 number. Find the missing number
without selecting individually each field in Action Class from jsp,what is the best process to select as many as field at a time automatically from jsp page by using value object class.
i want to insert textbox value to sql db. i have only one text box but store four values. ple give any one give sample code in asp.net c#..
