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

Which Department has MOST NUMBER of employees?

Answer Posted / senthil

select column_name,count(*)from table_name group by
column_name having count(*)=(select max(count(*)) from
table_name group by column_name);

PLZ Contact Any Queries (raja.prem86@gmail.com)

Is This Answer Correct ?    20 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When do you get a .pll extension in oracle?

1146


How to create a table index?

1155


What is the difference between pre-select and pre-query?

1222


What is bulk load in oracle?

1071


What are group functions in oracle?

1044


What are the different types of failures that occur in Oracle database?

1068


Explain the use of file option in exp command.

1132


How to get execution statistics reports on query statements?

1095


Oracle

2380


Can we insert data in view oracle?

1042


What is MTTR advisor in Oracle?

1090


How to estimate disk space needed for an export job?

1051


What is user managed backup in Oracle?

1146


What suggestions do you have to reduce the network traffic?

964


What is the parameter mode that can be passed to a procedure?

1051