It isn't possible to me to write a single query.You can first assign a

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'

Question Posted / shahbaz maqsood

2 Answers
5530 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

Please Help Members By Posting Answers For Below Questions

it is a language or tools?

2029

Can anyone send me NIC question papers alongwith answers on nidhi1485@yahoo.co.in? Urgently needed.. Thanks in advance

2325

I need source code for Enrollment System using Visual Basic 6.0/2008 database MS Access 2007 for my school thesis project...please help me..kindly send in my email jpinedamcp@gmail.com

1988

what will we require to build project with the help of oracle

1786

define profiler???

1994

Diff between IF and where ?

2001

Explain with examples any 2 features of OOPS.

1072

What is Negative testing?

2043

any drawback are there in mantis?

2088

what is meant by life cycle of a business

2207

what is an INI file?

2042

hii I inntrested abt scjp certification but i dont knw abt scjp plz send details abt scjp exam and syllabus.

1794

HOW TO FIND NUMBER OF TWOS IN N!(N FACTORIAL)??

2208

what are the 3 forms of a prolog term

3190

i want to improve my english vocab for racking campus written exam plz tell me best book for prepration......

2108