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...

how to achieve this problem?i am having table with two
colums like empno,gender.
in gender column, i am having records male,female like that
.my final output will be
male female
5 6

Answer Posted / venkat

select Count(gender) from emp group by gender with rollup

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is file based approach?

946


Explain the difference in execution of triggers and stored procedures?

1026


Explain locks? : Transact sql

1012


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1083


What do you mean by stored procedures?

1020


How do I run a pl sql program?

1136


How do you use a while loop in pl sql?

1021


What is data modelling in sql?

1031


Which table is left in left join?

1023


What is range partitioning?

975


what is innodb? : Sql dba

1116


What does (+) mean in sql joins?

1073


what are date and time functions in mysql? : Sql dba

986


Why sql query is slow?

1006


Can one improve the performance of sql*loader? : aql loader

1055