
用什么陳述句可以在最下面添加哪行合計,謝謝大神賜教。
uj5u.com熱心網友回復:
樓主百度一下 roolup,正好適用你現在的需求。uj5u.com熱心網友回復:
with a as (select 1 A ,'A' B FROM DUAL UNION ALL
SELECT 2 ,'B' FROM DUAL UNION ALL
SELECT 3 ,'C' FROM DUAL UNION ALL
SELECT 4,'D' FROM DUAL UNION ALL
SELECT 5,'E' FROM DUAL
)SELECT B,A FROM A union all select '合計',sum(a) from a;
uj5u.com熱心網友回復:
rollupuj5u.com熱心網友回復:
謝謝各位
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/90793.html
標籤:開發
上一篇:ERROR Unknown error when running consumer: (kafka.tools.ConsoleConsumer$)
