sqlserver 查询每小时订单数

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