SUM() OVER (ORDER BY..)

Anthony Damico ajdamico at gmail.com
Fri Apr 29 09:28:42 CEST 2016


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 ;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20160429/8d1108fd/attachment.html>


More information about the users-list mailing list