Hello !
This sql example on the new window function docs is missing the
parenthesis on the "rank" function:
===
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