SQL10 - 获取所有非manager的员工emp_no

题目描述:

获取所有非manager的员工emp_no
 1 CREATE TABLE `dept_manager` (
 2 `dept_no` char(4) NOT NULL,
 3 `emp_no` int(11) NOT NULL,
 4 `from_date` date NOT NULL,
 5 `to_date` date NOT NULL,
 6 PRIMARY KEY (`emp_no`,`dept_no`));

 7 CREATE TABLE `employees` (
 8 `emp_no` int(11) NOT NULL,
 9 `birth_date` date NOT NULL,
10 `first_name` varchar(14) NOT NULL,
11 `last_name` varchar(16) NOT NULL,
12 `gender` char(1) NOT NULL,
13 `hire_date` date NOT NULL,
14 PRIMARY KEY (`emp_no`));
 

难易程度:

中等

 

解答:

1 select distinct employees.emp_no
2 from employees 
3 left join dept_manager 
4 on employees.emp_no = dept_manager.emp_no
5 where employees.emp_no not in (select distinct emp_no from dept_manager)
 
 
posted @ 2020-09-30 10:51  Python小白白  阅读(200)  评论(0)    收藏  举报