SUM() OVER (ORDER BY..)
roberto.cornacchia at gmail.com
Fri Apr 29 09:37:22 CEST 2016
I think what you are looking for is SUM(..) OVER(PARTITION BY ..)
Otherwise where would the groups for the sum come from?
On 29 April 2016 at 09:28, Anthony Damico <ajdamico at gmail.com> wrote:
> hi, monetdb does not support SUM() OVER commands.. does anyone have a
> smart alternative to implement this? thanks
> SUM(job_count) OVER (ORDER BY duration) as cumjobs,
> SUM(job_count) over () as totjobs,
> test_data ;
> users-list mailing list
> users-list at monetdb.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the users-list