sql-server - 如何设置订单条款

Question

select 
   DATENAME(MONTH,LIFTINGDATE) as [Month],
   sum(liftingbirds)[LiftingBirds],
   round(sum(totalweight),0)[Tot.Weight],
   round(sum(totalamount),0)[Tot.Amount],
   round(sum(totalweight)/sum(liftingbirds),2)[Avg.Weight],
   Round(Sum(Totalamount)/Sum(totalweight),2)[Avg.Rate] 
from k_LiftingEntryRecords 
where (liftingdate BETWEEN '2013-04-01 00:00.000' AND getdate())
group by DATENAME(MONTH,LIFTINGDATE)  order by  DATENAME(MONTH,LIFTINGDATE)

如何订购。我哪里出错了。 O/P 即将到来，比如六月、四月、八月。期望的操作是四月、六月、七月

Answer 1

 select DATENAME(MONTH,LIFTINGDATE) as [Month],sum(liftingbirds)[LiftingBirds],
   round(sum(totalweight),0)[Tot.Weight],
   round(sum(totalamount),0)[Tot.Amount],
   round(sum(totalweight)/sum(liftingbirds),2)[Avg.Weight],
   Round(Sum(Totalamount)/Sum(totalweight),2)[Avg.Rate]
   from k_LiftingEntryRecords where 
  (liftingdate BETWEEN '2013-04-01 00:00.000' AND getdate())
   group by DATENAME(MONTH,LIFTINGDATE) ,Month(liftingdate) 
   order by Month(liftingdate) 

试试这个......