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 are the different types of failures that occur in Oracle database?

1116

What are the differences between date and timestamp in oracle?

1093

Explain self joins in oracle?

1059

Why does Oracle not permit the use of PCTUSED with indexes?

2478

How to define a record variable to store a table row?

1109

How to drop a stored procedure in oracle?

1102

How to create a new oracle data file?

1074

What is concurrency in oracle?

1055

Explain the use of record length option in exp command.

1117

What is control file used for?

1298

What are the different types of record groups in oracle? Explain each of them

1069

Explain what does a control file contain?

1159

What do you mean by group by clause?

1090

Can we write insert statement in function in oracle?

1153

How to filter out duplications in the returning rows using oracle?

1064