Sample Header Ad - 728x90

count of rows in table day wise

0 votes
1 answer
645 views
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