Groups > comp.databases.postgresql > #789

dense_rank MAX over preceding 3 days?

Newsgroups	comp.databases.postgresql
Date	2017-08-13 04:48 -0700
Message-ID	<f8f99226-b285-40d7-a234-3a428a8dfdf0@googlegroups.com> (permalink)
Subject	dense_rank MAX over preceding 3 days?
From	Alec Taylor <alec.taylor6@gmail.com>

Show all headers | View raw

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

Back to comp.databases.postgresql | Previous | Next — 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