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 online and offline backups?

1035

Describe the types of sub query?

979

How do we get field detail of a table?

1055

What is a cursor variable?

1098

Is oracle the best database?

949

How to convert numbers to characters in oracle?

1023

What is the data pump export utility?

1060

Explain what are the type of synonyms?

1089

interview questions with answer for cts

2568

What happens in oracle commit?

998

Difference between inner join vs where ?

1009

What are the different pseudo commands? Explain in general?

1055

What is sharded cluster?

992

Explain index?

1240

What is a procedure in oracle?

1151