hi, monetdb does not support SUM() OVER commands..  does anyone have a smart alternative to implement this?  thanks


    SELECT
        batch_id,
        job_count,
        SUM(job_count) OVER (ORDER BY duration) as cumjobs,
        SUM(job_count) over () as totjobs,
        duration
    FROM
        test_data ;