select time ,evg(timecount ) from(
select time,count(*) as timecount from(
select ip,format('yyyy-mm-dd hh',time) as time from table) group by time)
group by time
注:format('yyyy-mm-dd hh',time)这个函数的具体写法不知道了,这样表达的目的就是说要把你登入的日期格式化为'yyyy-mm-dd hh'样式的才好处理
select time,count(*) as timecount from(
select ip,format('yyyy-mm-dd hh',time) as time from table) group by time)
group by time
注:format('yyyy-mm-dd hh',time)这个函数的具体写法不知道了,这样表达的目的就是说要把你登入的日期格式化为'yyyy-mm-dd hh'样式的才好处理