SELECT
e.emp_no,
s.salary
FROM
employees e
INNER JOIN salaries s ON e.emp_no = s.emp_no
AND e.hire_date = s.from_date
ORDER BY
e.emp_no DESC
牛客SQL练习-6-查找所有员工入职时候的薪水情况
最新推荐文章于 2024-04-04 11:00:00 发布
SELECT
e.emp_no,
s.salary
FROM
employees e
INNER JOIN salaries s ON e.emp_no = s.emp_no
AND e.hire_date = s.from_date
ORDER BY
e.emp_no DESC