On 07/02/2018 03:14 PM, Domingo Alvarez Duarte wrote:
Hello !
This sql example on the new window function docs is missing the
parenthesis on the "rank" function:
Thanks for pointing this out. New version uploaded now.
Dan.
===
SELECT x, y, row_number() OVER*win1*, rank OVER*win2* FROM t0 --<<<<<
here the rank function is missing "()"
WINDOW*win1* AS (ORDER BY y RANGE BETWEEN UNBOUNDED PRECEDING AND
CURRENT ROW),
*win2* AS (PARTITION BY y ORDER BY x)
ORDER BY x;
===
Cheers !
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
