Hei,
Thank you very much! Cool!
I make it work like this:
SELECT r.day, r.a, SUM(r.a) OVER part_month AS cumulative_a
FROM
(
SELECT day, month, COUNT (DISTINCT (a))
FROM table
WHERE month='xx'
GROUP BY day, month
)r
WINDOW part_month as (PARTITION BY r.month order by r.day)
Greetings from F
Hey,
You could try something like
SELECT sum(a) OVER (PARTITION BY dummy ROWS UNBOUNDED PRECEDING) FROM (SELECT
a, “dummy” AS dummy FROM table) AS aux;
The smaller solution of :
SELECT sum(A) OVER (PARTITION BY “dummy” ROWS UNBOUNDED PRECEDING) FROM table;
For me gets stuck without presenting
