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
解决方案 »
- win2k,xp,2003下怎么判断当前用户是否超级用户呢?
- 求助:有关DBGRID中实现复选框的问题?
- 多声卡播放
- xpmenu怎么安装?(只有这么点分了)
- 大家好,给你们拜个年了。祝大家新年走好运,走财运,走桃花运!!!!
- 高分求救!!!QRREPORT中如何对每页的数据用SUMMARYBAND进行统计!最后再合计!!!急急
- 模拟按住键盘空格键持续输入空格的效果!
- 链接服务器,按日期范围统计,第一次正确再次统计混乱!求解!
- 如何改变richedit中1行的颜色?我的char数组中存放的不可见字符,如何让richedit显示出来?
- 周末想做什么,统计程序员周末风情!!!
- 请教高手:数据库中bit字段在dbgrid中显示情况?!
- 求一个sql语句,我认为有点难度!
是不是要这个
Select ServerIP,ModCode,Count(*)
From Table
Group By ServerIP,ModCode
select ServerIP, ModCode, count(*)
from yourtable
group by ServerIP, ModCode
group by serverip,modcode
select ServerIP, Count(Type)
from Table
where Type = -1
Group By ServerIP
from tableA
where type=1
group by ServerIP,ModCode
Select ServerIP,ModCode,Count(*)
From Table
where type=1
Group By ServerIP,ModCode
都行哇 还贴两遍阿
From Table
where type=1
Group By ServerIP,ModCodeSelect ServerIP,ModCode,Count(*)
From Table
where type=-1
Group By ServerIP,ModCode
select serverip, Modcode,count(*) from
(select serverip, clientip,modcode,count(*)
from sysclientlog
where logType = 1
group by serverip, clientip,modcode
)
group by serverip, Modcode