SQLServer降雨量雨强数据按照1小时，3小时，6小时进行统计

查找了很多资料，写完发现也很简单，分享给大家。
SELECT
T.STCD,
T.STNM,
SUM (T.DRP) AS SUMDRP,
T.hourTM * 1 AS hourTM,
T.YMDTM AS YMDTM
FROM
(
SELECT
o.STCD,
a.STNM,
o.TM,
o.DRP,
(
datename(yyyy, TM) + datename(mm, TM) + datename(dd, TM)
) AS YMDTM,
(
datename(hh, o.TM)
) / 1 AS hourTM
FROM
ST_PPTN_R o LEFT JOIN ST_STBPRP_B a ON o.STCD = a.STCD
WHERE
o.TM BETWEEN ‘2019-07-16 00:00:00’
AND ‘2019-07-17 23:59:59’
AND a.ADDVCD like ‘410324%’
) AS T
GROUP BY
T.hourTM,
T.YMDTM,
T.STCD,
T.STNM
ORDER BY SUMDRP DESC