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'
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
what is the difference between read the data from table and infotype
how do i add a column dynamically in a table by using java application?
How does the type system works when there is interoperability between a COM and .Net, i mean what exactly happens there
My Qualification is MCA.My interview is on 5th may.They may ask q as------AS u r MCA...Why u r not tring anywhere else? What can be the ans?
EXPLAIN UNARY OPEARATORS
can we retrieve only integer/String type columns from a table,if yes how?
Given a Binary Search Tree, write a program to print the kth smallest element without using any static/global variable. You can?t pass the value k to any function also.
what is difference between kpo and it industry? that is in terms of work, package etc
Outline the two important features of a terminating recursion. Any ideas?
Explain what is OOPS and its concepts?
In an customer exit (include Z) program, only the last record is getting fetched. The exit is getting called after pressing save button. What to write for fetching the first record ? Before saved to a SAP table how can i call all these records in an itab in the exit ?
what is the similarity between networking devices?
1. Write a program to create a sentence at runtime and count number of vowels in it ? 2. Write a program to get a string and to convert the 1st letter of it to uppercase ?
What is abstract Method i want the exact definition and is there any possibility to declare class as abstract without any abstract methods in that class?If it is possible then tell me why and how?
i want to insert textbox value to sql db. i have only one text box but store four values. ple give any one give sample code in asp.net c#..