题解 | #查找当前薪水详情以及部门编号dept_no#
查找当前薪水详情以及部门编号dept_no
https://www.nowcoder.com/practice/c63c5b54d86e4c6d880e4834bfd70c3b?tpId=82&tqId=29755&rp=1&ru=/exam/oj&qru=/exam/oj&sourceUrl=%2Fexam%2Foj%3Fpage%3D1%26tab%3DSQL%25E7%25AF%2587%26topicId%3D82&difficulty=undefined&judgeStatus=undefined&tags=&title=
SELECT d.emp_no, salary, from_date, d.to_date, d.dept_no
FROM salaries s
JOIN dept_manager d USING(emp_no)
ORDER BY emp_no
