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

表字段如下：
ID   CheckId
1        1
1        0
1        2
1        1
1        3
1        0
1        0
2        2
2        3
2        3

统计结果要求如下：

ID   “0”   “1”   “2”   “3”
1       3       2       1       1
2       0       0       1       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

其他：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 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 

上一个：dreamweaver 8中连接 access数据库面板上显示表为无 怎么解决
下一个：asp+access的系统怎么把数据库变成SQL Server 2000