Hi Simon
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 ); It works perfectly in SQL, but in SQLite it gives an error message : Error while executing SQL query on database 'weegbrugGeskiedenis': near "(": syntax error The squigly red line starts at (PARTITION .. Regards _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users