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

SELECT STCD, CONVERT(VARCHAR(10), TM, 120) AS Date, SUM(DRP) AS TotalRainfall FROM your_table WHERE DATEPART(HOUR, TM) = 8 GROUP BY STCD, CONVERT(VARCHAR(10), TM, 120) HAVING SUM(DRP) > 0;