sql server数据分组统计

1使用查询所得的结果集进行再分组统计示例格式.

select * 
from
 (select count(*) as QuantityA, sum(ol_sum) as Amount_A from tbl_orderlist
    where year(OL_RegTime)=year(getdate()) and month(OL_RegTime)=month(getdate()) ) A,     
 (select count(*) as QuantityB, sum(ol_sum) as Amount_B from tbl_orderlist
    where ol_sum>30 and ol_sum<=50) B,
 (select count(*) as QuantityC, sum(ol_sum) as Amount_C from tbl_orderlist
    where ol_sum>50 and ol_sum<=80) C,
 (select count(*) as QuantityD, sum(ol_sum) as Amount_D from tbl_orderlist
    where ol_sum>80 and ol_sum<=100) D,
 (select count(*) as QuantityE, sum(ol_sum) as Amount_E from tbl_orderlist
    where ol_sum>100) E

2,对于按日期及时间的分组统计

select month(A.OL_RegTime) as StrMonth,count(*) as QuantityA, sum(ol_sum) as Amount_A
from tbl_orderlist A
where year(A.OL_RegTime)=year(getdate())
group by month(A.OL_RegTime) order by strmonth

        在许多项目中开发都涉及到数据统计的问题,应用高效、快速的sql查询可以加快系统的反应，提高用户体验的使用满意度。根据以往经验得出，系统设计应基于这种思路。以上只是一些启发性的应用，在实际的开发进程中融入这种设计思想将会做出较高质量系统。设计追求精益求精.