yql/essentials/tests/sql/suites/select_yql/window_sum.yql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

PRAGMA YqlSelect = 'force';

SELECT
    a,
    Sum(b) OVER ()
FROM (
    VALUES
        (1, 001),
        (2, 002),
        (2, 020),
        (3, 003),
        (3, 030),
        (3, 300)
) AS x (
    a,
    b
);