sql - Oracle 数据库查询待解决

Question

create table employee
    (emp_id     integer     not null,
     manager_id     integer     not null,   
     emp_name   char(20)    not null,
     emp_tel    char(10),
     emp_salary number      not null,
     hire_date  date,
    constraint pk_employee primary key(emp_id)
    );

alter table employee 
add constraint fk_employee_manager foreign key(manager_id) 
references employee(emp_id);

需要帮助来查找与他们一起工作的员工超过 5 名的经理的 ID。

标签： sqloracle10g

Answer 1

只需这样做：您需要熟悉分组功能的可能性

select manager_id     
from employee
group by manager_id     
having count(*)>5