SELECT
CODE,TM,SUM(DRP)
FROM
xxTable
WHERE
CODE= '409K0044' and `TM` >= '2023-01-01 08:00:00'
AND MOD ( unix_timestamp( `TM` ) - unix_timestamp( '2023-01-01 08:00:00' ), 24 * 60 * 60 ) BETWEEN 0 AND 1
GROUP BY CODE,TM
DRP是需要统计累计的数据字段，TM是日期字段
标签：00,01,CODE,统计数据,DRP,间隔,60,TM,Mysql From： https://www.cnblogs.com/shuishuowobushihuiyuan/p/17609162.html