In https://www.sqlite.org/draft/windowfunctions.html:
"Window functions may only appears in the result set and..."
s/appears/appear/
"If default is also provided, then it is returned instead of NULL
if row identified by offset does not exist."
s/if row/if the row/ # 2 places - both lead() and lag() functions
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
