Re: Recreating a dated series from a change log
Sorry,
The suggested query contains a typo:
Øystein Grøvlen Wrote:
-------------------------------------------------------
> SELECT d.T_day, p.units
> FROM T_days AS d JOIN puc_changes AS p ON p.T_day < d.T_day
It should be "p.T_day <= d.T_day"
> WHERE d.T_day BETWEEN '2015-02-24' AND '2015-03-04'
> AND p.T_day = (SELECT MAX(T_day) FROM puc_changes WHERE T_day <= d.T_day);
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Written By
Posted
Re: Recreating a dated series from a change log
April 28, 2015 08:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.