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
- 5572 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
10.Define filters,binary to hexadecimal,hexadecimal to decimal?
Find out the list of roles which gives access to GUI activities? thanks in advance
can we extend a class having only one parameterised constructor.Suggest the process to do it.
How do you pass variables forwrd to future CECI sessions
Explain three modes in which files can be accessed from python program
pleasew define carrier scope in abap (sap).
Find out the list of authorization objects which contains activity as a field? Thanks in advance.
What sysoption determines where the macro facility searches a specific catalog for complied macro?
Q2. A memory location has physical address D5687h. Compute: a. The offset address if the segment number is D445h. b. The segment number if the offset address is B577h.
purpose of abstraction and interface
Write a pascal program to calculate the sum of the first 100 even number and odd number
Where do we need Operator overloading?
What is SAP TAO? · Which Version you are using? · What is the Latest Version in SAP TAO? · What are the Advantages in SAP TAO? · What are the Patches required for SAP TAO? · What is BPT? · Difference between BPT & SAP TAO? · Which Framework using for SAP TAO? · What is CBASE? · What is the SAP TAO Architecture? · What are the Prerequisites for SAP TAO? · SAP Solution Manager Mandatory for SAP TAO 1.0? · SAP Solution Manager Mandatory for SAP TAO 2.X? · What is UI Scanner? · What is Inspector? · How many ways to Create a components using TAO 1.0? · How many ways to Create a components using TAO 2.x? · Which service pack required for SAP TAO 2.7? · What is Import/Export? · What is Consolidate?
8.In DSP,Define Signal and System?and various type of signals.
sample and simple coding where we get?
