题解 | SQL202 查找当前薪水详情以及部门编号dept_no
WITH t1 AS (
SELECT *
FROM dept_manager
WHERE to_date = '9999-01-01'
),
t2 AS (
SELECT *
FROM salaries
WHERE to_date = '9999-01-01'
),
t3 AS (
SELECT
t1.emp_no,
t2.salary,
t2.from_date,
t2.to_date,
t1.dept_no
FROM t1
LEFT JOIN t2
ON t1.emp_no = t2.emp_no
ORDER BY t1.emp_no ASC
)
SELECT * FROM t3;
