【求合计】用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;