oracle 怎么样加一行做统计
怎样让添加最后一行然后是一列的合计
最新回答
你伴我暖
2026-10-23 11:50:19
select t.*
from (SELECT '1' AS A, '1' AS B, '1' AS C
FROM DUAL
UNION ALL
SELECT '2' AS A, '2' AS B, '2' AS C
FROM DUAL
UNION ALL
SELECT '3' AS A, '3' AS B, '3' AS C
FROM DUAL
UNION ALL
SELECT '4' AS A, '4' AS B, '4' AS C
FROM DUAL
UNION ALL
SELECT '5' AS A, '5' AS B, '5' AS C
FROM DUAL) t
UNION
select '合计:' || to_char(sum(f.A)),
'合计:' || to_char(sum(f.B)),
'合计:' || to_char(sum(f.C))
from (SELECT '1' AS A, '1' AS B, '1' AS C
FROM DUAL
UNION ALL
SELECT '2' AS A, '2' AS B, '2' AS C
FROM DUAL
UNION ALL
SELECT '3' AS A, '3' AS B, '3' AS C
FROM DUAL
UNION ALL
SELECT '4' AS A, '4' AS B, '4' AS C
FROM DUAL
UNION ALL
SELECT '5' AS A, '5' AS B, '5' AS C
FROM DUAL) f
热门标签
