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
- 5680 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
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 |
what is diff bet ref variable & instance of class
what is the BAM? where we can use it in BizTalk server?
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?
kindly send interview materials
When we delete logfiles such as screenshots how does it affect the ldf file? Ive seen huge change while adding screenshots in the ldf file but a very minor one deleting them.Please Explain
I want to insert date in the form of yyyy-mm-dd... if any changes happen while inserting date format want to show error meg...any one can solve this..??
How many processes can listen on a single TCP/IP port?
how to stop execution of step 3 in a job mainframe
why we use abstract word in abstract window toolkit in java language.
why Java is not purely object oriented?
What are data structures?
What is the best action a system can take when deadlock is detected
C 
