On Dec 3, 2019, at 5:38 AM, [email protected] wrote:
>
> The squigly red line starts at (PARTITION ..
PARTITION BY is a valid SQLite window function:
https://www.sqlite.org/windowfunctions.html#the_partition_by_clause
but that feature is only about a year old in SQLite:
https://blog.xojo.com/2018/12/18/sqlite-3-25-adds-window-functions-and-improves-alter-table/
Are you using at least SQLite 3.25?
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
