We can do this using a window function. SELECT store_id, sum(amount) OVER (PARTITION BY store_id) FROM sales. which results in: ...
確定! 回上一頁