思路1
先找出有5个下属的经理的Id
SELECT name
FROM Employee
WHERE id IN (
SELECT managerId
FROM Employee
GROUP BY managerId
HAVING COUNT(*)>=5);
Last updated
Was this helpful?
先找出有5个下属的经理的Id
SELECT name
FROM Employee
WHERE id IN (
SELECT managerId
FROM Employee
GROUP BY managerId
HAVING COUNT(*)>=5);
Last updated
Was this helpful?