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
- 17785 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 replace not in with not exist?
where the dff data will be stored
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
key flexfield structure
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
what are basic modules required to implement oracle application in any oraganisation?
How would you determine who has added a row to a table?
HOW TO SPOT AHIERARCHY?
which one is currently in used software cmpanies.
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
what are the API of GL,PO,AP
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is mrc and what is its use? : oracle accounts receivable
