I am trying to get a count of the number of files my company has received in the past month split up by each day. The example below shows what I want the output to look like.
| Date- | | -Received- | |--------| |------------| | 2/1/20 | | - 16 - | | 2/2/20 | | - 26 - | | 2/3/20 | | - 14 - | | 2/4/20 | | - 32 - |
The PK for my table is RecNo and the date variable is DateRecd.
Thank you in advance!
Advertisement
Answer
Do you just want aggregation and filtering?
select date, count(*) from t where date > convert(date, dateadd(day, -30, getdate())) group by date order by date;