sql server计算不同项目个数的一条sql语句

select max(id) as status,sum(case when attendance='出勤' then 1 else 0 end) as attendance,sum(case when schoolWork='完成' then 1 else 0 end) as schoolWork,sum(case when exercise='完成' then 1 else 0 end )as exercise,sum(case when word='完成' then 1 else 0 end) as word ,sum(case when text='完成'  then 1 else 0 end) as text from status where studentNo='条件'

 

注释:其中attendance，schoolWork，exercise，word，text均为数据库中的列名，此方法同样适用于mysql