SELECT
a.emp_no,
a.salary,
sum( b.salary )
FROM
salaries AS a,
salaries AS b
WHERE
b.emp_no <= a.emp_no
AND a.to_date = '9999-01-01'
AND b.to_date = '9999-01-01'
GROUP BY
a.emp_no
牛客SQL练习-60-统计salary的累计和running_total,其中running_total为前N个当前( to_date = ‘9999-01-01‘)员工的salary累计和
最新推荐文章于 2022-06-26 16:55:39 发布