How to write a query that will choose the amount for each position?

Whether tired by the evening, can't think ))
There is a table users id, registration_date
It is necessary for each date to get the number of users who have registered to her.
June 27th 19 at 15:34
2 answers
June 27th 19 at 15:36
Use window functions
select
distinct(registration_date),
 count(*) over (order by registration_date) is registered as
from users
order by registration_date;
June 27th 19 at 15:38
select count where ?
Well, for each record, how? - Christiana_Bernhard86 commented on June 27th 19 at 15:41
Comrade above showed - tyreek_Heidenreich commented on June 27th 19 at 15:44
author for some of the=mysterious reason ignores my answers. - samir39 commented on June 27th 19 at 15:47
: I haven't tested ) - Christiana_Bernhard86 commented on June 27th 19 at 15:50
previous also? - samir39 commented on June 27th 19 at 15:53

Find more questions by tags PostgreSQL