mysql sum of data per hour

Nervous Nightingale answered on September 8, 2022 Popularity 6/10 Helpfulness 2/10

answer mysql sum of data per hour

Comment

SELECT HOUR(e.time) as Hour,count(*) as Count 
	FROM error_log e 
	WHERE e.date = '2017-09-02' 
	GROUP BY HOUR(e.time) ORDER BY Hour(e.time);
1
2
3
4

Popularity 6/10 Helpfulness 2/10 Language sql

Source: blog.csdn.net

Tags: hour mysql sql sum

Link to this answer
Share Copy Link

Contributed on Sep 08 2022

Nervous Nightingale

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.