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

material view and view disadvantages?

1127

what is Single Byte Overhead...?

2614

Why is oracle database so popular?

1075

definition of cluster and non-clustered index?

3107

Where do we use decode and case statements?

1063

What is the difference between postgresql and oracle?

1108

Explain constraining triggers.

1167

How to work with data objects interactively?

1043

State some uses of redo log files?

1068

What are the logical operations?

1174

How to check your oracle database 10g xe installation?

1053

How do I start tns listener?

1099

Can multiple columns be used in group by in oracle?

1038

What is a parameter file in oracle?

1191

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

1111