回复：请教SQL高手一个问题,先谢了

来源: sub101 于 2008-03-07 12:48:40 [] [旧帖] [给我悄悄话] 阅读数 : 0 (192 bytes)

Select e1.Department, count (e1.id) as “number of employees”
From Employees e1
inner join employees e2 on e1.manager_id=e2.id
Where e1.Salary > e2.salary
Group by e1.Department

请您先登陆，再发跟帖！