Grouping records by their respective month and year based on a date column can be done really easily by simply running the following SQL query:
SELECT DATEPART(MONTH, DownloadDate) AS Month, DATEPART(YEAR, DownloadDate) AS Year, COUNT(DownloadID) AS NumberOfItems FROM Download GROUP BY DATEPART(YEAR, DownloadDate), DATEPART(MONTH, DownloadDate) ORDER BY Year DESC, NumberOfItems DESC
As you can see from the query (above), I am using the "DownloadDate" column to group my records and to also get a count of how many records belong to that month and year.
Before you go...
If you've found this post helpful, you can buy me a coffee. It's certainly not necessary but much appreciated!
Leave A Comment
If you have any questions or suggestions, feel free to leave a comment. I do get inundated with messages regarding my posts via LinkedIn and leaving a comment below is a better place to have an open discussion. Your comment will not only help others, but also myself.