Which Department has MOST NUMBER of employees?
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
Where do you use decode and case statements?
What are the database administrators utilities available?
What privilege is needed for a user to query tables in another schema?
Explain oracle insert into command?
Explain an index?
what are the default admin accounts in Oracle 10g ?
What is the sid in oracle?
What are ddl statements in oracle?
How to check your oracle database 10g xe installation?
How to create a stored program unit?
What is an oracle tablespace?
Explain the difference between a procedure and a function? What do you understand by those terms?
What happens in oracle commit?
Which are the five query types available in oracle?
State some uses of redo log files?