Question

数据分类统计 asp

有一个数据表user,里面有字段jibie(分1、2、3、4、5).那我要分别统计出jibie为1、2、3、4、5的会员数量。
但是我不知道怎么写，希望高手能帮忙！
怎么把统计结果显示出来呢？

Answer 1

select count(jibie) from user group by jibie

补充:
显示？你是指用 ADO RecordSet 吧，加个别名。另外 user 可能是保留字，扩起来

select count(jibie) as jibies from [user] group by jibie

要统计各级别这样做

select count(jibie) as count1 from [user] where jibie = 1
select count(jibie) as count1 from [user] where jibie = 2
...
或者
select count(jibie) as count1 from [user] group by jibie order by jibie
......
for i= 1 to rs.recordsetcount
response.write "等级" & i & ":" & & rs("count1")
rs.movenext
next

Answer 2

对