这种单用group by 是取不出来的。where htime BETWEEN '晚上5点' AND '次日晚上5点' group by htime //htime为你的分组字段;
group by语句在使用的时候必须要有统计函数,没有好像不能够直接分组
SELECT COUNT( * ) , FROM_UNIXTIME( created + 5*3600, '%Y%m%d' ) FROM `table` GROUP BY from_unixtime( created + 5*3600 , '%Y%m%d' ) DESC created为你要分组的字段
SELECT COUNT( * ) , FROM_UNIXTIME( created + 5*3600, '%Y%m%d' )
FROM `table`
GROUP BY from_unixtime( created + 5*3600 , '%Y%m%d' ) DESC
created为你要分组的字段