datawarehouse
- 浏览: 736 次
- 性别:
- 来自: 上海
-
最新评论
文章列表
select t1.ip,count(ip) aanum,d15mi
from RPT_BAK_20120512 t1,
where t1.type = '2'
group by wapgw_ip,d15mi
结果：
ip aanum d15mi
10.138.250.103 18 201205120015
10.136.16.197 8 201205120015
10.255.235.223 1 201205120130
10.179.185.209 3 201205120130
10.137.59.23 10 201205120215
1 ...