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

全部评论

相关推荐

点赞 评论 收藏
分享
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务