SELECT
HOUR (时间) AS HOUR,
COUNT(
CASE
WHEN orderlist.State = 1 THEN
orderlist.State
END
) AS suCount,
COUNT(
CASE
WHEN orderlist.State = 0 THEN
orderlist.State
END
) AS failCount,
数据列,
数据列,
数据列
FROM
orderlist
WHERE
时间 BETWEEN '开始时间'
AND '结束时间'
GROUP BY
HOUR (时间)
ORDER BY
HOUR (时间)
时间格式:yyyy-MM-dd HH:mm:ss