I have a sales table that looks like below:
I would like to display sales data month wise in the below format:
Can anyone help me with SQL for this?
Asked
Active
Viewed 29 times
0
-
You're asking for pivoting. There are a lot of related questions that show how to do it either for fixed or dynamic row values – Panagiotis Kanavos Jul 16 '20 at 13:08
-
Those 2 duplicates should be all the "help" you need. – Larnu Jul 16 '20 at 13:11