sql server 统计指定时间内每个小时的记录总数

 SELECT
       CONVERT(date, tTime) AS date_only,
       DATEPART(HOUR, tTime) AS hour_only,
       COUNT(*) AS record_count
   FROM
       T1
   WHERE
       tTime BETWEEN '2024-10-16 00:00:00' AND '2024-10-16 23:59:59'
   GROUP BY
       CONVERT(date, tTime),
       DATEPART(HOUR, tTime)
   ORDER BY
       CONVERT(date, tTime),
       DATEPART(HOUR, tTime);

本文来自 www.LuoFenMing.com