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

How many categories of data types in oracle?

1029


How to view the data files in the current database?

1096


What are the database administrators utilities available?

1030


How to get a list of all user accounts in the database?

1087


What is the difference between Delete, Truncate and Drop in Oracle?

1129


How to connect to a local oracle 10g xe server?

992


How to convert a string to a date in oracle database?

1052


What happens in oracle commit?

1024


What are the original export and import utilities?

1168


various types of hints and their usage

2696


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2008


What are the uses of Database Trigger ?

1719


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5549


What are internal user account in oracle?

1004


Explain joins in oracle?

1035