Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51422 Views
- IBM, LeadSquared, Mastek, I also Faced
- E-Mail Answers
Answer Posted / cvsrao
select d.deptname, count(*) as cnt from Employee e inner join
Department d on e.DeptId=d.DeptID
group by DeptName
having count(*) in
(select count(*) from
(select DeptId, count(*) as cnt from Employee group by DeptId)as cnt)
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What privilege is needed for a user to insert rows to tables in another schema?
what is the scripts in data base?
What do you mean by merge in oracle and how can you merge two tables?
What are the general rules on data consistency?
When do you get a .pll extension in oracle?
How to create a table in a specific tablespace?
What is merge statement used for?
How to export data with a field delimiter?
How to create additional tablespaces for an new database?
How to define an anonymous procedure with variables?
Explain table?
What is the maximum number of triggers that can be applied to a single table?
What is oracle database 10g express edition?
Can we write dml statement in function in oracle?
What are the predefined tablespaces in a database?
