56,867
社区成员




select Date,case hour(Time)
when 0 then '0-1'
when 1 then '1-2'
when 2 then '2-3'
when 3 then '3-4'
when 4 then '4-5'
when 5 then '5-6'
when 6 then '6-7'
when 7 then '7-8'
when 8 then '8-9'
when 9 then '9-10'
when 10 then '10-11'
when 11 then '11-12'
when 12 then '12-13'
when 13 then '13-14'
when 14 then '14-15'
when 15 then '15-16'
when 16 then '16-17'
when 17 then '17-18'
when 18 then '18-19'
when 19 then '19-20'
when 20 then '20-21'
when 21 then '21-22'
when 22 then '22-23'
when 23 then '23-0'
end `Hour` ,count(UserName) RecordCnt from table
group by Date,hour(Time)
order by Date,hour(Time)