合计语句
SELECT * from student
UNION
SELECT '','合计','','','',to_char(sum(PLUS)),to_char(sum(REDUCE)),'',sum(plus) from student
注意:数据类型和数量要保持一致。
合计语句
SELECT * from student
UNION
SELECT '','合计','','','',to_char(sum(PLUS)),to_char(sum(REDUCE)),'',sum(plus) from student
注意:数据类型和数量要保持一致。