sqlserver 查询每小时订单数

最新推荐文章于 2024-08-26 20:07:15 发布

Ms___

最新推荐文章于 2024-08-26 20:07:15 发布

阅读量3.3k

点赞数

分类专栏： sqlserver

本文链接：https://blog.youkuaiyun.com/Ms___/article/details/84237902

版权

sqlserver 专栏收录该内容

5 篇文章

订阅专栏

select * from (SELECT  datepart(hour,oper_date) AS oper_date, COUNT(*) AS voice_sum                  
FROM      tb_voice_info
where CONVERT(char(10), oper_date, 120)=CONVERT(char(10), getdate(), 120)
GROUP BY datepart(hour,oper_date)) 
as p
PIVOT 
(
    SUM(voice_sum) FOR 
    p.oper_date IN ([0],[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17],[18],[19],[20],[21],[22],[23])
) AS T