I am looking to pull a closing balance from the database for each month.
I have tried
SELECT CloseBal As 'Balance', MONTHNAME(DateTime) as 'Month', DateTime
Group By Month
I am getting an error
invalud use of grouping function
What would be the best way to achieve this?