sql语句的问题,解决后马上结账!!

数据库中记录如下
023 1
023 2
024 1
023 3
023 4
024 2
023 1
..........
现在需要的目的是
id 是1的总数 不是1的总数
023 3 3
024 2 0
.......................

在线等,解决问题马上结账
---------------------------------------------------------------

select id,sum(case 条件=1 then 1 else 0 end),sum(case 条件<>1 then 1 else 0 end) from table group by id
---------------------------------------------------------------

select id,
sum(case when dd='1' then 1 else 0 end)as 是1的总数,
sum(case when dd<>'1' then 1 else 0 end)as 不是1的总数
from tbname
group by id
---------------------------------------------------------------

Select D.id,D.yes,D.no from(
SELECT C.id,A.YES,B.NO FROM Table C,
(select count() as yes from table where id='A00001') A,
(select count(
) as no from talble where id<>'A00001') B
) D
---------------------------------------------------------------

select id,sum(case when........end),sum(case when ......end)from table group by id

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus