I need to get a count of rows in a table day wise.
The table looks like below:
Table ABC:
f_id|reg_date
1|2020-09-08
2|2020-09-12
3|2020-10-01
4|2020-09-07
5|2020-09-08
6|2020-09-09
Expected output if I am running query saying I want the count of rows till 2020-09-15 since a week before of 15th:
count|date
1|2020-09-07
3|2020-09-08
4|2020-09-09
4|2020-09-10
4|2020-09-11
5|2020-09-12
5|2020-09-13
5|2020-09-14
I am not sure how to get this above output.
The rouble with the date range and group by is just giving me the the count of rows for that date, not a total of the count till that date. For example group by date gives me: 1|2020-09-07, 2|2020-09-08 and so on.
Asked by ssssss
(3 rep)
Oct 8, 2020, 01:37 PM
Last activity: Oct 22, 2020, 07:44 AM
Last activity: Oct 22, 2020, 07:44 AM