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

Which Department has MOST NUMBER of employees?

Question Posted / sts

8 Answers
50748 Views
IBM, LeadSquared, Mastek, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what are the uses of rollback segment?

961

What do you know about normalization? Explain in detail?

881

What are the different windows events activated at runtime ?

2834

What is Java Pool in Oracle?

1094

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2262

Why oracle is used?

998

Can we use bind variables in oracle stored procedure?

899

Explain the use of rows option in imp command.

1042

How do you bind variables in oracle?

931

How a database is related to tablespaces?

986

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

2513

Why do you use stored procedures and state some of its disadvantages?

970

What is difference between cartesian join and cross join?

1018

Explain integrity constraints?

1060

What is the difference between postgresql and oracle?

980