SqlServer 根据时间统计数据展示图表

概述  --本年 select m as [Date],sum(case when datepart(month,CreateDateTime)=m then 1 else 0 end )as [Count] from [dbo].CrmCustomer c, (select 1 m union all select 2 union all selec

 

  --本年  select   m as [Date],sum(case when datepart(month,CreateDateTime)=m then 1 else 0 end )as [Count]     from [dbo].CrmCustomer c,(select 1 m     union all select 2      union all select 3     union all select 4    union all select 5     union all select 6      union all select 7     union all select 8      union all select 9      union all select 10      union all select 11      union all select 12) aa where  ‘2018‘= year(CreateDateTime) group by   m;            --本月    select DATEPART(day,CreateDateTime) as [Date],COUNT(ID) AS [Count] from [dbo].CrmCustomer     WHERE   DATEPART(mm,CreateDateTime) = DATEPART(mm,GETDATE()) and DATEPART(yy,CreateDateTime) = DATEPART(yy,GETDATE())     group by DATEPART(day,CreateDateTime)           
--本周                       select convert(nvarchar(10),CreateDateTime,120) AS [Date],COUNT(ID) as [Count] from [dbo].CrmCustomer     where datediff(week,getdate())=0 group by convert(nvarchar(10),120)

总结

以上是内存溢出为你收集整理的SqlServer 根据时间统计数据展示图表全部内容，希望文章能够帮你解决SqlServer 根据时间统计数据展示图表所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。