本文介绍了一种使用SQL语句来汇总2008年特定时间段内的销售数据的方法，包括现金销售额、账户销售额及总销售额，并按集群代码进行分组。
通过下面的这种语句,可以对GROUP BY的数据进行COUNT统计:)
Select count(*) From T_Sale_Lead t
Where t.id In(Select max(t.id) From T_Sale_Lead t Where t.T_Happen_Year=2008 and
t.T_Happen_Month In(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
Group by t.T_Cluster_Code,t.T_Happen_Year,t.T_Happen_Month )
下面是hql的语句:)
Select t.TClusterCode,t.THappenYear,t.THappenMonth,Sum(t.TCashChnNum) ,Sum(t.TAccChnNum),Sum(t.TSaleChnNum) From TSaleLead t Where t.THappenYear=2008 and t.THappenMonth In(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) Group by t.TClusterCode,t.THappenYear,t.THappenMonth order by t.TClusterCode desc
Select count(*) From T_Sale_Lead t
Where t.id In(Select max(t.id) From T_Sale_Lead t Where t.T_Happen_Year=2008 and
t.T_Happen_Month In(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
Group by t.T_Cluster_Code,t.T_Happen_Year,t.T_Happen_Month )
下面是hql的语句:)
Select t.TClusterCode,t.THappenYear,t.THappenMonth,Sum(t.TCashChnNum) ,Sum(t.TAccChnNum),Sum(t.TSaleChnNum) From TSaleLead t Where t.THappenYear=2008 and t.THappenMonth In(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) Group by t.TClusterCode,t.THappenYear,t.THappenMonth order by t.TClusterCode desc
扫一扫
1123
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
