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