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, 47781 }

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