############高分----sql语句------################

[ruide205]

表名:table
字段:fclass(取值1 2 3 4等),fresult(取值 胜 平 负)
要求:列出结果
fclass count(*) count(fresult=胜)

[cqusgx]

你是用什么鉴定方法，什么值为“胜”可以用decode函数吧

[sasacat]

select fclass,count(*),sum(case fresult when '胜' then 1 else 0 end)
from table
group by fclass

[waterfirer]

select fclass,count(fclass),(select count(*) from table
where fclass=a.fclass and fresult='胜') from table a group by fclass

[超叔csdn]

select count(*),count(decode(fresult,'胜',1,null))
from table

[沝林]

select fclass,count(*),count(decode(fresult,'胜',1))
from tablename
group by fclass

[waterfirer]

sasacat(傻傻猫)的好，也可以用decode
select fclass,count(*),sum(decode(fresult,'胜',1,0))
from table
group by fclass

[超叔csdn]

select count(*),count(decode(fresult,'胜',1,null))
from table
group by fclass

[海阔天空1977]

我顶呀！

[小李木耳]

select fclass ,
(select count(*) from table ),
(select count(*) from table where fresult='胜')
from table

[ruide205]

Decode的方法经实践是可用的!水清兄的子查讯方法在9i表中是可用的,在视图或在8i不可行,傻傻猫兄的case方法不能写在8i中,在9i中也是可行的!
谢谢!