Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51158 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
How do I connect to oracle database?
How to check the oracle tns settings?
What is rich query?
What are the logical operations?
Why does for update in oracle 8 cause an ora-01002 error?
State all possible different index configurations a table can possibly have?
What are the different types of partitions in oracle?
How can we force the database to use the user specified rollback segment?
How translate command is different from replace?
What are the predefined tablespaces in a database?
How to list all tables in your schema?
what are the default admin accounts in Oracle 10g ?
How to end the current transaction in oracle?
What are the uses of a database trigger?
What is oracle and what are its different editions?
