I am trying to count the dates between a range. I have looked here but this is not working for me.
Here is a sample of my table
repo | revision | date | author
test | 1 | 01/01/2011 | chris
test | 2 | 01/01/2011 | chris
test | 3 | 01/02/2011 | chris
select date, count(*)
where repo = 'test' and date between '01/01/2011' and '01/01/2017'
group by date;
If you want the number of distinct dates, then use
select repo, count(distinct date) from SVNLogEntry where repo = 'test' and date between '2011-01-01' and '2017-01-01' group by repo;
To get them per
repo, then use
group by repo, not
group by date.