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 a server parameter file in oracle?

1058

What is object data modeling?

965

Why use resource manager in Oracle?

1105

What is raw datatype in oracle?

1135

what is the difference between substr and instr function in oracle?

1090

Is it possible to insert comments into sql statements return in the data model editor ?

2559

What is where clause in oracle?

1031

Is oracle a relational database?

916

What does sharding mean?

1000

What are the execution control statements?

1063

Can multiple cursors being opened at the same time?

1060

Explain the use of consistent option in exp command.

1066

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

1040

What happens if recursive calls get out of control?

1082

Is primary key indexed by default in oracle?

987