oracle如何使用sql求行的合计和列的合计
//合计行
SELECT code, SUM(amount) AS total_amount
FROM sales
GROUP BY ROLLUP (code);
//合计列
SELECT code,
amount,
SUM(amount) OVER (PARTITION BY code) AS total_amount_per_code
FROM sales;
//合计行
SELECT code, SUM(amount) AS total_amount
FROM sales
GROUP BY ROLLUP (code);
//合计列
SELECT code,
amount,
SUM(amount) OVER (PARTITION BY code) AS total_amount_per_code
FROM sales;