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
What is the oracle implicit cursor?
What is the dynamic sql in oracle?
What is the scope of a local variable?
When do you get a .pll extension in oracle? Explain its importance
what are steps for interface? where is exchange rate defined in which table?
How do I recompile a procedure in oracle?
What is an oracle recycle bin?
How to retrieve data from an cursor to a record?
What is a procedure in oracle?
Explain coalesce function?
What is the usage of control file in oracle?
How to speed up webrick?
master table and child table performances and comparisons in Oracle ?
Explain the different normalization forms?
How to import one table back from a dump file?