CREATE TABLE USER_LOGIN (
LOGIN_DATE DATE,
LOGIN_COUNT INTEGER
);
INSERT INTO USER_LOGIN VALUES
('2021-04-01', 100),
('2021-04-02', 150),
('2021-04-03', 200),
('2021-04-04', 50);
输出->
LOGIN_DATE LOGIN_COUNT
2021-04-01 100
2021-04-02 250
2021-04-03 450
2021-04-04 500
您可以在此处使用SUM
作为分析函数来生成滚动和:
SELECT LOGIN_DATE, SUM(LOGIN_COUNT) OVER (ORDER BY LOGIN_DATE) LOGIN_COUNT
FROM USER_LOGIN
ORDER BY LOGIN_DATE;