去指定时间范围内,每个小时的一条数据
SELECT * FROM (SELECT * FROM table where time > 1397050237 and time < 1397100000)a group by (time div 3600)
去指定时间范围内,每个小时的一条数据
SELECT * FROM (SELECT * FROM table where time > 1397050237 and time < 1397100000)a group by (time div 3600)