Select Deptno,Count(*) from Emp Group By Deptno having Count(*)=(SELECT max

Which Department has MOST NUMBER of employees?

Question Posted / sts

Answer Posted / sts

Select Deptno,Count(*) from Emp Group By Deptno having Count(*)=(SELECT max (count(*)) FROM EMP GROUP BY DEPTNO);

Is This Answer Correct ?

24 Yes

13 No

Please Help Members By Posting Answers For Below Questions

What is translate in oracle?

1078

What is the difference between translate and replace?

1047

How to select an oracle system id (sid)?

1046

How to import one table back from a dump file?

1008

What is system global area (sga) in oracle?

965

what are the default admin accounts in Oracle 10g ?

951

What is the maximum limit on the number of columns in a table?

1067

Explain a segment?

1070

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1632

How to sort output in descending order in oracle?

1024

In the oracle version 9.3.0.5.0, what does each number shows?

1278

How to increment dates by 1 in oracle?

1035

What types of joins are used in writing subqueries?

965

What is SQL Tuning Advisor in Oracle?

1146

How to get the Installed Oracle Version Information ?

1106