Re: FW: SQL rolling window without aggregation

Поиск
Список
Период
Сортировка
От AJ Welch
Тема Re: FW: SQL rolling window without aggregation
Дата
Msg-id CAO-RzRK6E-y0aPiFb-kpdM+DmHVCLeB49gEcWZyqwbe9HZsjDg@mail.gmail.com
обсуждение исходный текст
Ответ на FW: SQL rolling window without aggregation  ("Huang, Suya" <Suya.Huang@au.experian.com>)
Список pgsql-general
Дерево обсуждения
I believe this can be accomplished with lead() and union: http://sqlfiddle.com/#!15/521d5/7

Thanks,
AJ

On Sun, Dec 7, 2014 at 3:13 PM, Huang, Suya <Suya.Huang@au.experian.com> wrote:

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-sql@postgresql.org'
Subject: [SQL] rolling window without aggregation

 

Hi SQL experts,

 

I’ve got a question here, is that possible to implement a window function without aggregation? Any SQL could get below desired result?

 

For example:

 

Table input

    date    | id

------------+--------

2014-04-26 | A

2014-05-03 | B

2014-05-10 | C

2014-05-17 | D

2014-05-24 | E

2014-05-31 | F

 

Expected output, use 2 week roll up as an example:

    date    | id

------------+--------

2014-04-26 | A

2014-05-03 | A

2014-05-03 | B

2014-05-10 | B

2014-05-10 | C

2014-05-17 | C

2014-05-17 | D

2014-05-24 | D

2014-05-24 | E

2014-05-31 | E

2014-05-31 | F

 

 

 

Thanks,

Suya


В списке pgsql-general по дате отправления:

Предыдущее
От: "Huang, Suya"
Дата:
Сообщение: FW: SQL rolling window without aggregation
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Strange behavior in generate_series(date, date, interval) with DST