> Subject: Re: FW: [GENERAL] SQL rolling window without aggregation
>
> Huang, Suya wrote
> > It seems like it's not been sent to the SQL group, so I'm trying with
> > this group.
>
> Asked and answered...online archives follow
>
>
> http://postgre
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G Johnston
Sent: Monday, December 08, 2014 1:18 PM
To: pgsql-general@postgresql.org
Subject: Re: FW: [GENERAL] SQL rolling window without aggregation
Huang, Suya
928965-5829345.p...@n5.nabble.com
David J.
--
View this message in context:
http://postgresql.nabble.com/FW-GENERAL-SQL-rolling-window-without-aggregation-tp5829528p5829564.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing lis
I believe this can be accomplished with lead() and union:
http://sqlfiddle.com/#!15/521d5/7
Thanks,
AJ
https://www.linkedin.com/in/ajw0100
On Sun, Dec 7, 2014 at 3:13 PM, Huang, Suya
wrote:
> It seems like it’s not been sent to the SQL group, so I’m trying with
> this group.
>
>
>
> Thanks,
>
It seems like it's not been sent to the SQL group, so I'm trying with this
group.
Thanks,
Suya
From: Huang, Suya
Sent: Friday, December 05, 2014 6:25 PM
To: 'pgsql-...@postgresql.org'
Subject: [SQL] rolling window without aggregation
Hi SQL experts,
I've got a question here, is that possible t
