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
