/
krasninja
/
querycat
Обзор
Документация
Войти
/
krasninja
/
querycat
Код
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/QueryCat.IntegrationTests/Tests/SelectWindow1.yaml
15 строк
381 B
Ivan Kozhin
Initial implementation of "first_value" and "last_value" functions
26 фев 2023, 10:21
26 фев 2023, 10:21
0db7dff
Код
Авторство
О чём код?
expected: | aleksander,999,1805,1999 elina,800,803,2799 ivan,1000,2289,1000 lena,780,1286,3579 sergey,500,503,4079 query: | select name, balance, sum(balance + 3) over (w1) as 'window1', sum(balance) over (order by balance desc) as 'window2' from 'Simple2.csv' window w as (partition by country || city order by balance), w1 as (w) order by name;