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
- 4681 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
how can i create report in abap to insert data in table pa0002 using insert command
Q1.Write a C program which asks the user for a number between 1 to 9 and shows the number. If the user inputs a number out of the specified range, the program should show an error and prompt the user for a valid input.
how to convert hashmap to arraylist with iteration
How does the TCP handle the issue of multiplexing?
Hi Guys, This is Rama, right now I am working as a Software Test Engineer in Gurgoan and I have over all 3 years of testing expoeriance. Right now I am looking for a change. Can any body help me out to find a job in south india. Thanks in Advance
What is easiest way to get the PL/i compiler,I didn't have found the compiler in my library. Is there any extra cost if we want to access the PL/1 programs?Actually we r having Mainframe rented training Ids
how pseudo column works?
what is dot net framework
what is the main usage of an abstract keyword?please follow the program class A { void display() { System.out.println("hai"); } void print() { } } class B extends A { void print() { System.out.println("Hello"); } } In this program i was gives the implementation of print() according to my requirements in subclass.And there is no definition in superclass then why we can use abstract keyword before a method that i want to gives definition in other classes,is any mistakes in the above usage of method?
Hai, My name is nisha.I have NIC exam.If anybody Knows NIC previous paper pattern pls send me to nishanairp@gmail.com
how can we implement locks in plsql?
hi viewers, tell me,what is scripting and programming, define and difference...pls
what is the difference between SCAN AND CHECK,LOKUP AND XFOOT? where we can use thease opcodes? Can any body tell me real time senariao with example?
Display names and numbers of employees who have 5 years or more experience and salary less than Rs.15000 using array of structures (name, number, experience and salary)
through which algorithm does the garbage collector works? how the garbage collector will understand that the object will going to be deleted?
