On Tuesday, 3 December, 2019 05:39, gideo...@lutzvillevineyards.com wrote:
>My query is : >UPDATE wbridge_history >SET yearclass = >( >SELECT D.wynklas >FROM >( >SELECT LidNo, PlaasNo, BlokNo, oesjaar, wynklas, >ROW_NUMBER() OVER (PARTITION BY LidNo, PlaasNo, BlokNo, oesjaar ORDER BY >COUNT(*) DESC, SUM(ton) DESC) AS row_num FROM wbridge_history GROUP BY >LidNo, Plaasno, BlokNo, oesjaar, wynklas >) D >WHERE D.LidNo = wbridge_history.LidNo >AND D.PlaasNo = wbridge_history.PlaasNo >AND D.BlokNo = wbridge_history.BlokNo >AND D.oesjaar = wbridge_history.oesjaar >AND D.row_num = 1 >); This prepares without error on version 3.31.0 so, as Simon says, you probably just have a version of SQLite3 that does not do window functions (ie, prior to 3.25.0) in which ROW_NUMBER() would have been parsed as a function call, OVER as a column alias name, and the "(" as a syntax error (only a "," the keyword "FROM", or the end of statement ";" could validly appear after an expression in the select list). -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users