TDate Type ServerIP ClientIP ModCode AppVersion
2005-07-26 1 192.168.100.41 192.168.101.238 WardNurse 2.0.10.90
2005-07-27 1 192.168.100.40 192.168.10.55 InputCost 1.0.1.1
2005-07-28 1 192.168.100.41 192.168.101.237 WardNurse 2.0.10.90
2005-07-29 1 192.168.100.41 192.168.101.238 WardNurse 2.0.10.90
2005-07-30 1 192.168.100.22 192.168.101.133 ClinPhar 1.0.0.7
2005-07-31 1 192.168.100.41 192.168.131.146 InputCost 1.0.0.1
2005-08-01 -1 192.168.100.41 192.168.101.238 WardNurse 2.0.10.90
2005-08-02 -1 192.168.100.41 192.168.101.237 WardNurse 2.0.10.90
上面是数据表,要得到如下结果,其中Logtype的1表示正常登录-1表示正常登出,以下主要查看服务器负载多少客户端。ServerIP ModCode Count(*)192.168.100.22 ClinPhar 1
192.168.100.40 InputCost 1
192.168.100.41 InputCost 1
192.168.100.41 WardNurse 2
2005-07-26 1 192.168.100.41 192.168.101.238 WardNurse 2.0.10.90
2005-07-27 1 192.168.100.40 192.168.10.55 InputCost 1.0.1.1
2005-07-28 1 192.168.100.41 192.168.101.237 WardNurse 2.0.10.90
2005-07-29 1 192.168.100.41 192.168.101.238 WardNurse 2.0.10.90
2005-07-30 1 192.168.100.22 192.168.101.133 ClinPhar 1.0.0.7
2005-07-31 1 192.168.100.41 192.168.131.146 InputCost 1.0.0.1
2005-08-01 -1 192.168.100.41 192.168.101.238 WardNurse 2.0.10.90
2005-08-02 -1 192.168.100.41 192.168.101.237 WardNurse 2.0.10.90
上面是数据表,要得到如下结果,其中Logtype的1表示正常登录-1表示正常登出,以下主要查看服务器负载多少客户端。ServerIP ModCode Count(*)192.168.100.22 ClinPhar 1
192.168.100.40 InputCost 1
192.168.100.41 InputCost 1
192.168.100.41 WardNurse 2
解决方案 »
- 请问一下面试金融行业估计是炒股软件
- 我用delphi2006做mdi程序,vclskin3.99在mdi主窗体中时,窗体最大化不能充满整个桌面
- 如何让线程CPU占用率不要太高[只有这么多分, 如果需要以后补上]
- {$H+}...........{H-}什么意思,高人指教小弟这个菜鸟
- 我在使用函数WSAIoctl的时候需要设置一个参数SIO_KEEPALIVE_VALS。
- 二个stringgrid的使用方法?
- 想将JPG图片保存到BLOB字段中?请问我的代码哪里错了?
- 没人能解决这个问题啦?
- 怎样编程实现利用insert语句向oracle里导入数据?
- 问个很简单的问题,解答有分。
- 求一个sql语句,我认为有点难度!
- rxrichedit 中如何改片图片的大小?
是不是要这个
Select ServerIP,ModCode,Count(*)
From Table
Group By ServerIP,ModCode
group by serverip,modcode
select ServerIP, Count(Type)
from Table
where Type = -1
Group By ServerIP
from (select distinct Type ,ServerIP ,ClientIP,ModCode from tableA)
where type=1
group by ServerIP,ModCode
from tableA
where type=1
group by ServerIP,ModCode//修改了一下,这样更好
from tableA
where type=1
group by ServerIP,ModCode
Select ServerIP,ModCode,Count(*)
From Table
where type=1
Group By ServerIP,ModCode
都行
我的失误,最后得出结果的表有两个字段连在一起了。所以误导了各位。
现在要用两次分组查询,才能得出正确答案。
select serverip, Modcode,count(*) from
(select serverip, clientip,modcode,appversion,count(*)
from sysclientlog
where logType = 1
group by serverip, clientip,modcode,appversion
)
group by serverip, Modcode