Interview Questions Answers in Oracle General

venkat

{ City } hyderabad
< Country > india
* Profession * se
User No # 122136

Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 7

Questions / { venkat }

Questions Answers Category Views Company eMail

Answers / { venkat }

Question { IBM, 50753 }

Which Department has MOST NUMBER of employees?

Answer

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