'How to group by month with days
I'm new to SQL and I could use the help. I have a data set which I need to filter down. The data looks like this:
| code | date | quantity |
|---|---|---|
| code1 | 20210713 | 1.0000000000 |
| code1 | 20210719 | 4.0000000000 |
| code1 | 20210726 | 3.0000000000 |
code is nvarchar(85)
date is nvarchar(10)
quantity is numeric(38,15)
I'm tasked to get a list of data for the one code (code1). This data needs to show the quantity grouped by date. In months.
What's best way to do this with a bit of explanation behind it?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
