On Dec 3, 2019, at 5:38 AM, gideo...@lutzvillevineyards.com 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users