Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1127


Is there any link between pr form(purchse requisition)and po form(purchase order)

2679


what are the tools used for oracle 10g in real time.

2398


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2330


What is db_recovery_file_dest in oracle? When do you need to set this value?

1093


Explain prerequisites and post activities of oracle database installation

2093


How would you determine what sessions are connected and what resources they are waiting for?

2093


How to clone the database using RMAN back

2169


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?

2379


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2285


key flexfield structure

2135


What is chargeback invoice? How do we create it? : oracle accounts receivable

1305


I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2157


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

2485


i want to know about the javaBean.what is its purpose and how it can use in Forms.

2433