统计24小时,31天,12个月,4个季度。年
统计24小时数据
SELECT
dayHour NAMES,
ITEMNAME,
IF(VALUEA IS NULL, 0, VALUEA) AS VALUEA
FROM (SELECT
VALUEA,
ITEMNAME,
count(VALUEA) AS count,
DATE_FORMAT(CDATE, '%H')
AS hour
FROM pm_cs_save_hour...
原创
2018-12-18 16:55:50 ·
358 阅读 ·
0 评论