题解 | 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;