情况是这样的，有个表：
table1
type int
point int
现在想在一句SQL里求得如下几个值：
type =0 时的纪录总数
type =0 时的point数之和(sum)
type =0 AND point= 10 时的纪录数
type =0 AND point= 20 时的纪录数
请问有可能吗？
------解决方案--------------------
select count(type),sum(point),纪录数1=sum(case when point= 10 then 1 else 0 end),纪录数2=sum(case when point= 20 then 1 else 0 end)
from table1
where type=0
------解决方案--------------------
select
count(*),
sum(point),
sum(case point when 10 then 1 else 0 end),
sum(case point when 20 then 1 else 0 end)
from
表
where
type=0
------解决方案--------------------
select count(1),sum(point),sum(case when point=10 then 1 else 0 end),sum(case when point=20 then 1 else 0 end) from table1 where type=0
------解决方案--------------------
declare @table1 table(type int,point int)
insert @table1 select 0 ,20
union all select 0 ,20
union all select 0 ,10
union all select 0 ,10
select count(1),sum(point),(select count(1) from @table1 where type =0 AND point= 10)
,(select count(1) from @table1 where type =0 AND point= 20)
from @table1
where type =0