Ignore that, my bad. You can also aggregate over all rows, of course.



On 29 April 2016 at 09:37, Roberto Cornacchia <roberto.cornacchia@gmail.com> wrote:
I think what you are looking for is SUM(..) OVER(PARTITION BY ..)

Otherwise where would the groups for the sum come from?

Roberto

On 29 April 2016 at 09:28, Anthony Damico <ajdamico@gmail.com> wrote:
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 ;
       

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list