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
- 5662 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we write a method in JSP.If so how?
How do i find out the number of parameters passed into function?
how many types of operating system are avaliable?
Write a program to find factorial of a number using functions
MOV.CB 007H,ADCON1 MOVE.CT 001H,_OPTION_REG_7 MOV.CB 007H,CMCON
I want Ada programming language books. Could anyone post me any link for that?
< No Frames > tag is used for
I have try to write a record in a TDQ from a fle.... what are the steps to do... can anybody plz come with a solution
what is woransient key word? how it is used in java
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.
Write a shell program to test whether a given year is leap year or not ?
How does the TCP handle the issue of multiplexing?
I want to pass .pdf files as OlE Object to crystal report through VB6. Please any one guid me...
What is the merger sort principle and its time complexity.
Hi..Am done with my Masters recently..Am planning to learn TIBCO.. could anyone suggest me about how the job market will be and Is there any course necessary to learn prior to Tibco..i mean any prerequisite. I dnt have any knowledge on PL/SQL thats it... Plz suggest me in a best way...
