1.In a table Gender is a column in that male and female are
the two data.In a single statement i have to modify all male
to female and all female to male vice versa.
2.In a single query i need the count of male data,count of
female and total count
Answer Posted / kd
2.
select gender, count(*)
from employee
group by gender
union
select 'total' as gender, count(*)
from employee
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Is there any link between pr form(purchse requisition)and po form(purchase order)
what are the tools used for oracle 10g in real time.
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is db_recovery_file_dest in oracle? When do you need to set this value?
Explain prerequisites and post activities of oracle database installation
How would you determine what sessions are connected and what resources they are waiting for?
How to clone the database using RMAN back
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
key flexfield structure
What is chargeback invoice? How do we create it? : oracle accounts receivable
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
i want to know about the javaBean.what is its purpose and how it can use in Forms.