1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
I created a table as follows
create table periods
(
start_date date,
end_date date,
period_days numeric,
period_nbr numeric,
reverse_period numeric
);
I loaded some data
insert into periods
values(sysdate-1/24, sysdate, 1, 2, 3);
I was able to run the Redshift query you have provided without any errors.
SELECT
true AS cumulative,
(MIN(start_date) OVER (ORDER BY start_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW))::varchar(10)
|| ' - ' ||
(MAX(end_date) OVER (ORDER BY start_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW))::varchar(10) AS reporting_date,
MAX(period_nbr) OVER (ORDER BY start_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS period_nbr,
MIN(reverse_period) OVER (ORDER BY start_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS reverse_period,
SUM(period_days) OVER (ORDER BY start_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS period_days,
MIN(start_date) OVER (ORDER BY start_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS start_date,
MAX(end_date) OVER (ORDER BY start_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS end_date
FROM periods;
répondu il y a un an
Contenus pertinents
- demandé il y a un an
- demandé il y a 7 mois
- demandé il y a 3 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 2 ans