@tobias.koetter thank you for this hint this opens up the whole world of window functions. I downloaded the latest JAR file from the Maven site and told KNIME where to find the driver.
@khatuaani now you can benefit from the latest developments with H2 (and SQLite).