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

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2199


Use of an integrity constraint is better to validate data. Explain

979


What is rowid and rownum in oracle?

955


What is oracle database client?

976


What are the attributes that are found in a cursor?

1013


Explain about achiever in sql?

981


How to Truncate Table in Oracle

1094


What is the difference between alert log file and tarce file ?

2099


What are internal user account in oracle?

950


How to drop a tablespace?

984


State any two functions of oracle?

984


What the is the diff between local index and global index. give some example.

1590


Is oracle a programming language?

940


Explain coalesce function?

1119


What is SQL access advisor in Oracle?

1138