Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51167 Views
- IBM, LeadSquared, Mastek, I also Faced
- E-Mail Answers
Answer Posted / nannesaheb
SQL> Select Deptno,Count(*) from Emp
Group By Deptno
Having Count(*)=(Select Max(Count(*)) From Emp);
--If Any Queries Contact Me at nannesaheb.c@gmail.com
--Nannesaheb
| Is This Answer Correct ? | 8 Yes | 26 No |
Post New Answer View All Answers
Differentiate between post-database commit and post-form commit?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to store pictures on to the database?
Why is oracle database so popular?
In oracle there is column command, how will you explain that?
What is connection pooling in oracle?
How to get maxsal , minsal, ename department wise in single query
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Explain the difference between a procedure and a function? What do you understand by those terms?
How to recover a dropped table in oracle?
What is hash cluster in oracle?
How to turn on or off recycle bin for the instance?
Explain overloading. Can functions be overloaded?
WHAT IS ecc 6.0
What are the different windows events activated at runtime ?
