Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51059 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
What is oracle host variable?
How to view existing locks on the database?
What is hash cluster in oracle?
How to change program global area (pga) in oracle?
How to create a testing table in oracle?
How do we get field details of a table?
Can you create a synonym without having a table?
How to pass parameters to procedures in oracle?
What do you know about normalization? Explain in detail?
What is where clause in oracle?
How to speed up webrick?
how do u setup a replication site?
What are joins, explain all types of joins?
How to use null as conditions in oracle?
What is pragma autonomous transaction in oracle?
