Hi everyone,
I have a query as -
select DateName(Month,Date), avg(NetAmount) as AverageCustomerBill from salesmaster
group by DateName(Month,Date)
which gives result as follow -
April 451.5664
August 432.6227
July 441.1437
June 429.9915
May 423.7198
November 407.4123
October 425.1684
September 416.3678
As u can see here Months are not in proper sequence.....
Is there any way How I can get result in proper sequence of months
exa -
April --1212
May --32659
June --5478745
July --534658
August --3236
September --
October --
November --
December --
and so on...