SQL Server: 获取每天8点雨量数据并汇总降雨量

以下是你所需的SQL语句：

SELECT STCD, CONVERT(DATE, TM) AS Date, SUM(CASE WHEN DRP > 0 THEN DRP ELSE 0 END) AS Rainfall FROM [YourTableName] WHERE CONVERT(TIME, TM) = '08:00:00.000' GROUP BY STCD, CONVERT(DATE, TM)