[sqlite] Update SQLITE

I have the following SQLITE query : SELECT BlokkeklaarAliasnaam, BlokkeklaarKultivar, sum(BlokkeklaarSkatting) FROM Blokkeklaar GROUP BY BlokkeklaarAliasnaam, BlokkeklaarKultivar; I cannot

[sqlite] SQL to SQLite

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

[sqlite] SQL to SQLIte

I am having extreme difficulty to convert the above SQL query to SQLite. Can someone please help me. I need to udate the table using the most used text In a column for each row that has the same data. Regards ___ sqlite-users mailing list