有个time字段
想做个统计
统计每个时段的注册人数
比如统计今天24个时段之内的每个时段注册人数
意思是这样:
00:00 - 01:00
01:00 - 02:00
不知道SQL语句如何写
谢谢指点
想做个统计
统计每个时段的注册人数
比如统计今天24个时段之内的每个时段注册人数
意思是这样:
00:00 - 01:00
01:00 - 02:00
不知道SQL语句如何写
谢谢指点
解决方案 »
- 求助:Google +1 按钮优化
- 连接sqlserver数据库时含有特殊符号@$%^怎么处理
- smarty高手进!!
- php5.2.3与mysql彻底断绝关系了么?
- 有谁做过RSS聚合?
- 我這一句錯在哪裡?在JavaScript中插入php語句。
- 请看一下以下代码,为什么在43行出错,我对php不是太了解。所以一些工作原理还请执教
- 我的php的mysql已经设置完成可是他和我的mysql连不上??
- php soap调用的时候会自动访问到代理服务器,如何禁止路由到代理服务器?
- PHP用pdo连接ACCESS读取会乱码,怎么设置编码?
- PHP怎样使用文本框的全选..............................
- 请教高手一个正则表达式,关于过滤连接的
SELECT
CASE
WHEN `atvtime` >1282665600
AND `atvtime` <=1282669200
THEN '1'
WHEN `atvtime` >1282669200
AND `atvtime` <=1282672800
THEN '2'
WHEN `atvtime` >1282672800
AND `atvtime` <=1282676400
THEN '3'
WHEN `atvtime` >1282676400
AND `atvtime` <=1282680000
THEN '4'
WHEN `atvtime` >1282680000
AND `atvtime` <=1282683600
THEN '5'
WHEN `atvtime` >1282683600
AND `atvtime` <=1282687200
THEN '6'
WHEN `atvtime` >1282687200
AND `atvtime` <=1282690800
THEN '7'
WHEN `atvtime` >1282690800
AND `atvtime` <=1282694400
THEN '8'
WHEN `atvtime` >1282694400
AND `atvtime` <=1282698000
THEN '9'
WHEN `atvtime` >1282698000
AND `atvtime` <=1282701600
THEN '10'
WHEN `atvtime` >1282701600
AND `atvtime` <=1282705200
THEN '11'
WHEN `atvtime` >1282705200
AND `atvtime` <=1282708800
THEN '12'
WHEN `atvtime` >1282708800
AND `atvtime` <=1282712400
THEN '13'
WHEN `atvtime` >1282712400
AND `atvtime` <=1282716000
THEN '14'
WHEN `atvtime` >1282716000
AND `atvtime` <=1282719600
THEN '15'
WHEN `atvtime` >1282719600
AND `atvtime` <=1282723200
THEN '16'
WHEN `atvtime` >1282723200
AND `atvtime` <=1282726800
THEN '17'
WHEN `atvtime` >1282726800
AND `atvtime` <=1282730400
THEN '18'
WHEN `atvtime` >1282730400
AND `atvtime` <=1282734000
THEN '19'
WHEN `atvtime` >1282734000
AND `atvtime` <=1282737600
THEN '20'
WHEN `atvtime` >1282737600
AND `atvtime` <=1282741200
THEN '21'
WHEN `atvtime` >1282741200
AND `atvtime` <=1282744800
THEN '22'
WHEN `atvtime` >1282744800
AND `atvtime` <=1282748400
THEN '23'
WHEN `atvtime` >1282748400
AND `atvtime` <=1282751999
THEN '24'
END ct2, count( * ) AS ct
FROM bao_players_info
WHERE `atvtime` >=1282665600
AND `atvtime` <=1282751999
AND `atvgamestype` =11
GROUP BY
CASE
WHEN `atvtime` >1282665600
AND `atvtime` <=1282669200
THEN '1'
WHEN `atvtime` >1282669200
AND `atvtime` <=1282672800
THEN '2'
WHEN `atvtime` >1282672800
AND `atvtime` <=1282676400
THEN '3'
WHEN `atvtime` >1282676400
AND `atvtime` <=1282680000
THEN '4'
WHEN `atvtime` >1282680000
AND `atvtime` <=1282683600
THEN '5'
WHEN `atvtime` >1282683600
AND `atvtime` <=1282687200
THEN '6'
WHEN `atvtime` >1282687200
AND `atvtime` <=1282690800
THEN '7'
WHEN `atvtime` >1282690800
AND `atvtime` <=1282694400
THEN '8'
WHEN `atvtime` >1282694400
AND `atvtime` <=1282698000
THEN '9'
WHEN `atvtime` >1282698000
AND `atvtime` <=1282701600
THEN '10'
WHEN `atvtime` >1282701600
AND `atvtime` <=1282705200
THEN '11'
WHEN `atvtime` >1282705200
AND `atvtime` <=1282708800
THEN '12'
WHEN `atvtime` >1282708800
AND `atvtime` <=1282712400
THEN '13'
WHEN `atvtime` >1282712400
AND `atvtime` <=1282716000
THEN '14'
WHEN `atvtime` >1282716000
AND `atvtime` <=1282719600
THEN '15'
WHEN `atvtime` >1282719600
AND `atvtime` <=1282723200
THEN '16'
WHEN `atvtime` >1282723200
AND `atvtime` <=1282726800
THEN '17'
WHEN `atvtime` >1282726800
AND `atvtime` <=1282730400
THEN '18'
WHEN `atvtime` >1282730400
AND `atvtime` <=1282734000
THEN '19'
WHEN `atvtime` >1282734000
AND `atvtime` <=1282737600
THEN '20'
WHEN `atvtime` >1282737600
AND `atvtime` <=1282741200
THEN '21'
WHEN `atvtime` >1282741200
AND `atvtime` <=1282744800
THEN '22'
WHEN `atvtime` >1282744800
AND `atvtime` <=1282748400
THEN '23'
WHEN `atvtime` >1282748400
AND `atvtime` <=1282751999
THEN '24'
END
LIMIT 0 , 30
欢迎到 http://www.allniu.com/list.php?catid=33 去看看,好多MYSQL知识
这个也不行呢
select HOUR(`atvtime`) as hh,count(*) as cnt from bao_players_info WHERE `atvtime` >= 1282838400 AND `atvtime` <1283011199 group by hh
得到这个数据
hh cnt
NULL 63
838 30
保存的是 unix 时间戳?
怎么不早说?
要这样写
select FROM_UNIXTIME(`atvtime`, '%Y%m%d%H') as hh, count(*) as cnt from bao_players_info group by hh
FROM_UNIXTIME
又学了一个