Question

SQLserver的count方法如何统计多列

SELECT COUNT(status) AS COU,ROOMID,STATUS,nameroom,upperlimit FROM kg_V_assignclass WHERE(roomid>0) GROUP BY roomid,status,nameroom,upperlimit ORDER BY roomid

select count(1) AS num,sex,roomid from kg_person where(roomid>0) group by sex,roomid
我想要把这两个合为一个，统计出第一个status的和第二个sex的。求大神给予代码

Answer 1

什么意思, 第一条是统计status, 第二条是统计sex
你直含袭陪接把两个写在一起禅亮:
SELECT COUNT(status) AS COU, count(sex) as num,ROOMID,STATUS,nameroom,upperlimit FROM kg_V_assignclass WHERE(roomid>0) GROUP BY roomid,status,nameroom,upperlimit ORDER BY roomid

我没太看明白你的问题, 不知道你是不是想谈蠢要这样的效果