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 / ns

SELECT count(*), department_id
FROM employees
GROUP BY department_id
HAVING count(*) =
(SELECT max(count(*))
FROM employees
GROUP BY department_id)

Is This Answer Correct ?    40 Yes 46 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to manage transaction isolation level?

1006


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2288


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2470


What is a cognitive schema?

972


What are operators in oracle?

1057


Explain the use of compress option in exp command.

1021


What is the usage of analyze command in oracle?

1095


What is blob datatype?

1132


How to run the anonymous block again?

1132


how to do daily transactions with out sql* loader control file regesterd in apps?

1687


What is a snapshot log?

1005


What is the usage of synonyms?

1143


What is the difference between I and G in Oracle?

1099


How to initialize variables with default values?

1249


What is the difference between "as" and "is" in an oracle stored procedure?

994