62,046
社区成员
发帖
与我相关
我的任务
分享
SELECT UserSerID,
SUM( CASE WHEN TypeID = 'A' THEN
1 ELSE 0 END), --缺勤总次数
SUM( CASE WHEN TypeID = 'W' THEN
1 ELSE 0 END) --未交作业
FROM SX_SchAnnal
GROUP BY UserSerID
SELECT UserSerID,
SUM( CASE WHEN TypeID = 'A' THEN
1 ELSE 0 END), --缺勤总次数
SUM( CASE WHEN sex = 'W' THEN
1 ELSE 0 END) --未交作业
FROM SX_SchAnnal
GROUP BY UserSerID
select
sum(case TypeID when 'A' then 1 else 0 end) as '缺勤总次数',
count(*)-sum(case TypeID when 'A' then 1 else 0 end) as '未交作业数',
UserSerID as '学号'
from SX_SchAnnal
group by UserSerID
select
sum(case TypeID when A then 1 else 0 end) as '缺勤总次数',
count(*)-sum(case TypeID when A then 1 else 0 end) as '未交作业数',
UserSerID as '学号'
from SX_SchAnnal
group by UserSerID