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
- 5657 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 is delegate and how works delegate and event.
Difference between views and index in sas programming
You are given some denominations of coins in an array (int denom[])and infinite supply of all of them. Given an amount (int amount), find the minimum number of coins required to get the exact amount. What is the method called?
why we need to take u?
in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'
5. Which of the following can you do with DB2 Express- C? Query databases with SQL Query databases with XML using XQuery and XPath Use SQL in Xquery and Xquery in SQL All of the above
there are N number of matchboxes numbered 1...N.each matchbox contain various number of stick.Two player can alternatevely pick some amount of stick from the higest stick containing box . The player is condidered win if there is no stick after his move.Find the final move so that the move player win. Note:In case the number of stick is equal ,pick the stick from the higest numbered box. eg: 3 box contain stick as:1,1,1. if u take 1 stick from 3rd numbred box you will any how win the match.
For a binary tree with n nodes, How many nodes are there which has got both a parent and a child?
what is an INI file?
8.In DSP,Define Signal and System?and various type of signals.
In project we have Documentation phase also,in that what is micro and macro designing?
How to know we are in home page of a web application using QTP
what is best way to create a Thread class & why?
how to generate dsnless connectivity in j2ee
qtp 9.2 14 days demo version was expired.I uninstalled how to reinstall this again
