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
26
27
28
29
30
|
PRAGMA YqlSelect = 'force';
SELECT
Sum(salary) OVER w,
Avg(salary) OVER w
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
)
WINDOW
w AS (
PARTITION BY
depname
ORDER BY
salary DESC
)
;
|
