求一个sql语句，我认为有点难度！

[xthggg]

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

[wozhuchuanwei]

我觉得你说的不是很清楚！
是不是要这个
Select ServerIP,ModCode,Count(*)
From Table
Group By ServerIP,ModCode

[xixuemao]

select serverip,modcode,count(modcode) as num from test1 where type='1'
group by serverip,modcode

[xthmpro_cn]

请参考Group By
select ServerIP, Count(Type)
from Table
where Type = -1
Group By ServerIP

[loon1981]

用COUNT阿.

[merkey2002]

select ServerIP,ModCode ,count(*)
from (select distinct Type ,ServerIP ,ClientIP,ModCode from tableA)
where type=1
group by ServerIP,ModCode

[merkey2002]

select ServerIP,ModCode ,count(ClientIP)
from tableA
where type=1
group by ServerIP,ModCode

//修改了一下，这样更好

[cumtbwxj]

select ServerIP,ModCode ,count(ClientIP)
from tableA
where type=1
group by ServerIP,ModCode


Select ServerIP,ModCode,Count(*)
From Table
where type=1
Group By ServerIP,ModCode


都行

[jkx01whg]

up

[opqhjb_2002]

行的,就这样了

[WuChenCan]

楼主呢，快结贴吧

[zhilunchen]

没有什么难度啊,就是用两个字段分组的问题.

[xthggg]

我知道答案了，谢谢大家的帮助。
我的失误，最后得出结果的表有两个字段连在一起了。所以误导了各位。
现在要用两次分组查询，才能得出正确答案。
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