题解 | #查找所有员工的last_name和first_name以及对应的dept_name#
查找所有员工的last_name和first_name以及对应的dept_name
https://www.nowcoder.com/practice/5a7975fabe1146329cee4f670c27ad55
select
last_name,
first_name,
dept_name
from
dept_emp
left join departments on dept_emp.dept_no = departments.dept_no
right join employees on dept_emp.emp_no = employees.emp_no
查看20道真题和解析