/
krasninja
/
querycat
Обзор
Документация
Войти
/
krasninja
/
querycat
Код
Пакеты
0
Релизы
0
Аналитика
Безопасность
develop
src/QueryCat.IntegrationTests/Tests/SelectWindow2.yaml
15 строк
457 B
Ivan Kozhin
Initial implementation of "first_value" and "last_value" functions
26 фев 2023, 10:21
26 фев 2023, 10:21
0db7dff
Код
Авторство
О чём код?
expected: | 1,aleksander,999,aleksander,999 2,aleksander,999,elina,800 1,aleksander,999,ivan,1000 3,aleksander,999,lena,780 2,aleksander,999,sergey,500 query: | select row_number() over (partition by city order by balance), first_value(name) over (order by name), first_value(balance) over (order by name), last_value(name) over (order by name), last_value(balance) over (order by name) from 'Simple2.csv' order by name;