Database Development

Rearrange Month Wise data in sql query

Currently I am retrieving data month wise from below query

select  month(EntryDate) as m, sum(QTY) as QTY,Sum(IWeight) as Weight
from ConIssuance

where delid is null
group by  month(EntryDate)
Order by month(EntryDate) asc

Output Is coming

But i want below like output ( Means I want Last Year Month come above to till year month)

Leave a Reply

Your email address will not be published. Required fields are marked *