描述
- 求salary的累计和running_total
CREATE TABLE `salaries` ( `emp_no` int(11) NOT NULL,
`salary` int(11) NOT NULL,
`from_date` date NOT NULL,
`to_date` date NOT NULL,
PRIMARY KEY (`emp_no`,`from_date`));
考点
- 把sum聚合函数作为窗口函数使用
SELECT emp_no, salary
SUM(salary) OVER (ORDER BY emp_no) as running_total
FROM salaries
WHERE to_date = '9999-01-01'