selectcol_code,(selectsum(teacher_project_map.col_money)fromteacher_project_mapwhereteacher_project_map.col_code=base_teacher.col_code)assum1,(selectsum(teacher_reward_ma...
select col_code,(select sum(teacher_project_map.col_money) from teacher_project_map where teacher_project_map.col_code=base_teacher.col_code )as sum1,(select sum(teacher_reward_map.col_money) from teacher_reward_map where teacher_reward_map.col_code=base_teacher.col_code )as sum2,(select sum(teacher_paper_map.col_money) from teacher_paper_map where teacher_paper_map.col_code=base_teacher.col_code )as sum3,(select sum(col_money)from teacher_patent_map where teacher_patent_map.col_code=base_teacher.col_code)as sum4,(select sum(col_money) from teacher_standard_map where teacher_standard_map.col_code=base_teacher.col_code)as sum5,(select sum(col_money) from teacher_tachievement_map where teacher_tachievement_map.col_code=base_teacher.col_code)as sum6,(select sum1+sum2+sum3+sum4+sum5+sum6 )as sum7 from base_teacher where col_school = '信息中心' group by base_teacher.col_code
WITH ROLLUP
想要统计每列的和,我用的是WITH ROLLUP,为什么结果都是0? 有什么其他方法么?跪求大神指点,感激不尽!!!
展开