急,急,急 pl/sql ,oracle 根据查询结果统计数量
发布网友
发布时间:2023-07-10 04:12
我来回答
共4个回答
热心网友
时间:2023-10-11 20:11
select A.calssno, A.count_1, B.count_2, C.count_3
from
(select count(*) as count_1, calssno
from student_mart
where project = '语文'
and mark = 'D'
group by calssno) A,
(select count(*) as count_2, calssno
from student_mart
where project = '数学'
and mark = 'D'
group by calssno) B,
(select count(*) as count_3, calssno
from student_mart
where project = '英语'
and mark = 'D'
group by calssno) C
where A.calssno = B.calssno
and B.calssno = C.calssno
热心网友
时间:2023-10-11 20:11
SELECT calssno, 语文成绩为A的条数=COUNT(CASE WHEN project='语文' AND mark='A' THEN 1 END),数学成绩为B的条数=COUNT(CASE WHEN project='数学' AND mark='B' THEN 1 END),
英语成绩为C的条数=COUNT(CASE WHEN project='英语' AND mark='C' THEN 1 END)
FROM student_mart
GROUP BY calssno
热心网友
时间:2023-10-11 20:11
select count(*) from student_mart where mark='D' and project='语文'
union
select count(*) from student_mart where mark='D' and project='数学'
union
select count(*) from student_mart where mark='D' and project='英语'
热心网友
时间:2023-10-11 20:12
select project,count(*) from student_mart t where t.mark='D' group by t.project