问题描述
- 【菜鸟】求小计怎么写
-
求图中的小计怎么写?我已经写完了前边的
select
a.problem_generate_name as"problemGenerateName",
a.project_name as "projectName",
nvl(b.projectBugSum, 0) as projectBugSum,
nvl(c.heavy, 0) as heavy,
nvl(d.littleHeavy, 0) as littleHeavy,
nvl(e.general, 0) as general,
nvl(f.suggest, 0) as suggest
from ppm_project_plan a
left join (
select a.project_code, count(1) as projectBugSum
from ppm_project_plan a
where a.sort_mark = '2'
group by a.project_code) b on a.project_code = b.project_code
left join (
select a.project_code, count(1) as heavy
from ppm_project_plan a
where a.sort_mark = '2'
and a.problem_grade_code = 'WTDJ1001'
group by a.project_code) c on a.project_code = c.project_code
left join (
select a.project_code, count(1) as littleHeavy
from ppm_project_plan a
where a.sort_mark = '2'
and a.problem_grade_code = 'WTDJ1002'
group by a.project_code) d on a.project_code = d.project_code
left join (
select a.project_code, count(1) as general
from ppm_project_plan a
where a.sort_mark = '2'
and a.problem_grade_code = 'WTDJ1003'
group by a.project_code) e on a.project_code = e.project_code
left join (
select a.project_code, count(1) as suggest
from ppm_project_plan a
where a.sort_mark = '2'
and a.problem_grade_code = 'WTDJ1004'
group by a.project_code) f on a.project_code = f.project_code
where a.problem_generate_name is not null
group by a.problem_generate_name,a.project_name,nvl(b.projectBugSum, 0),nvl(c.heavy, 0),nvl(d.littleHeavy, 0),
nvl(e.general, 0),nvl(f.suggest, 0)
解决方案
select '小计',null,null,sum(需要求和的列名),... from(复制你上面写的那全部sql) as 别名
时间: 2024-08-29 03:54:04