Bubble2016

分类

题解(21)

/ 注册

全部文章（共2篇）

题解 | #查找所有已经分配部门的员工的last_name和first_name以及dept_no#

select e.last_name,e.first_name,d.dept_no from employees as e left join dept_emp as d on e.emp_no = d.emp_no where d.dept_no is not null;

Sqlite Mysql

2021-09-23

1 343

题解 | #查找当前薪水详情以及部门编号dept_no#

select s.emp_no,s.salary,s.from_date,s.to_date,d.dept_no from salaries as s left join dept_manager as d on s.emp_no = d.emp_no where d.dept_no is not ...

Sqlite Mysql

2021-09-23

1 369