Sql统计某一字段中每种情况的数量 Access数据库

2025-05-21 15:54:33

推荐回答（3个）

回答（1）：

select id,checkedid,count(checkedid) totalNUm
from tablename
group by id,checkedid
如果需要的话，可以加上order by totalNUm
以上代码在Oracle测试通过。
数据形式为
id checkedid totalNUm
1 0 3
1 1 2
1 2 1
1 3 1
2 2 1
2 3 2

回答（2）：

select id,sum(iif(CheckId=0,1,0)) as 0,sum(iif(CheckId=1,1,0)) as 1,sum(iif(CheckId=2,1,0)) as 2,sum(iif(CheckId=3,1,0)) as 3 from tableName group by id

回答（3）：

select ID,sum(field0) as field0,sum(field1) as field1,sum(field2) as field2,sum(field3) as field3
from
(select ID, case iif(CheckId='0',1,0) as field0,iif(CheckId='1',1,0) as field1,iif(CheckId='2',1,0) as field2,iif(CheckId='3',1,0) as field3 from 表名) aa
group by ID