Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17500 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
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
3. Steps in UAT?
difference of using cursor for loop and open,fetch,close.which one is better
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
How many segment are present in Oracle Manufacturing
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Give two methods you could use to determine what DDL changes have been made.
what are the API of GL,PO,AP
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
what are the tools used for oracle 10g in real time.
What is autocashrule set? : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
