SELECT count(*), department_id FROM employees GROUP BY department

Which Department has MOST NUMBER of employees?

Question Posted / ns

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

Please Help Members By Posting Answers For Below Questions

What is the difference between sharding and partitioning?

490

what's query optimization and without use of IN AND Exist can we get another way data from query

1653

Is oracle a relational database?

510

Will you be able to store pictures in the database?explain.

526

How to delete all rows a table in oracle?

611

What is a nvl function? How can it be used?

547

What are the different windows events activated at runtime ?

2395

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

533

What is a snapshot log?

557

How to create a new user account in oracle?

567

Explain the use of control file?

643

How do you store pictures in a database?

546

What is the meaning of recursive hints in oracle?

519

WHAT IS ecc 6.0

1642

How to load excel data sheet to oracle database

574