Groups > comp.databases.postgresql > #790

Re: dense_rank MAX over preceding 3 days?

From	Lennart Jonsson <erik.lennart.jonsson@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: dense_rank MAX over preceding 3 days?
Date	2017-08-14 14:28 +0200
Organization	A noiseless patient Spider
Message-ID	<oms4pn$pj2$1@dont-email.me> (permalink)
References	<f8f99226-b285-40d7-a234-3a428a8dfdf0@googlegroups.com>

Show all headers | View raw

On 08/13/2017 01:48 PM, Alec Taylor wrote:
> How do I get the MAX (or another aggregate function) for of a column of each row, OVER its preceding 3 days worth of rows?
> 
> SQL example with expected output and db schema: http://sqlfiddle.com/#!17/24686/3
> 
> Thanks for all suggestions
> 
> PS: Also interested with how I can cover 3 work days rather than calendar days
> 

Sketch:

MAX(x) OVER (PARTITION by ...
              ORDER BY ...
              RANGE BETWEEN CURRENT ROW AND 3 PRECEDING)

The groups I monitor on usenet have zero to none activity. I suggest you 
post your question on http://stackoverflow.com

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

dense_rank MAX over preceding 3 days? Alec Taylor <alec.taylor6@gmail.com> - 2017-08-13 04:48 -0700
  Re: dense_rank MAX over preceding 3 days? Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2017-08-14 14:28 +0200
    Re: dense_rank MAX over preceding 3 days? Robert Klemme <shortcutter@googlemail.com> - 2017-08-14 20:20 +0200
      Re: dense_rank MAX over preceding 3 days? Lennart Jonsson <erik.lennart.jonsson@gmail.com> - 2017-08-16 00:01 +0200

csiph-web