How can i solve the query...?

[abhaysk]

Select 
  Dept.Dname, A.Cnt
From 
  ( Select Dept_No, Count(*) Cnt From Emp Group By Dept_No Order By 2) A,
  Dept
Where
  A.Dept_No = Dept.Dept_No And
  Rownum < 2
;