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
- 3 Answers
- 16360 Views
- HP, I also Faced
- E-Mail Answers
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
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is auto invoicing? : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
which one is currently in used software cmpanies.
What do you mean by Oracle MEDIA RECOVERY?
What is the sql query to find the employee who has Nth maximum salary?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
Could you please let me know the interfaces in OM / FA??
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 is an Oracle database Partial Backup?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is the disk migration? what is the steps involved in oracle disk migration?
How many segment are present in Oracle Manufacturing
