1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
PRAGMA YqlSelect = 'force';
SELECT
salary,
Sum(salary) OVER (
ORDER BY
salary
)
FROM (
VALUES
('develop', 11, 5200),
('develop', 7, 4200),
('develop', 9, 4500),
('develop', 8, 6000),
('develop', 10, 5200),
('personne', 5, 3500),
('personne', 2, 3900),
('sales', 3, 4800),
('sales', 1, 5000),
('sales', 4, 4800)
) AS empsalary (
depname,
empno,
salary
);
|
