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
|
PRAGMA YqlSelect = 'force';
SELECT
depname,
empno,
salary,
RowNumber() OVER (
PARTITION BY
depname
ORDER BY
salary DESC
)
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
);
|
