oracle:
SELECT TRUNC(hold_trx_time, 'HH') AS hour, AVG(qty_1) as avg_qty
FROM a
WHERE TO_CHAR(hold_trx_time, 'HH24:MI:SS') >= '08:00:00' OR TO_CHAR(hold_trx_time, 'HH24:MI:SS') <= '08:00:00'
GROUP BY TRUNC(hold_trx_time, 'HH');
mysql:
SELECT DATE_FORMAT(hold_trx_time, '%Y-%m-%d %H:00:00') AS hour, AVG(qty_1) as avg_qty
FROM a
WHERE TIME(hold_trx_time) >= '08:00:00' OR TIME(hold_trx_time) <= '08:00:00'
GROUP BY DATE_FORMAT(hold_trx_time, '%Y-%m-%d %H');
1min目标场景问卷
立即参与
请教想计算8点到第二天8天每个小时的qty平均值，这个要怎么计算？
