I am facing an issue to get result in same row if the month is same. I am using UNION ALL in query. Can anyone please advise how to use the query to get result as per my requirement.
I am using below code:
SELECT SUM(amount) AS amount DATE_FORMAT(rcvdate'%M %Y') as rcv