Re: Total Stock (Roll Up)

[Peter Brawley]

Read the manual page on Group By.

select supplier, Sum(quantity) as Units_Sold
from sales
group by supplier with rollup;