running-totals in sql statement

[jonnyk]

I need to add a column to a sql statement that will give me a running total by group

sql is
selct item, week, sum(qty)
group by item, week

The column will need to add qty as a running total for each item for each week

Any ideas

 

[SQLSister]

Look at using the with rollup clause in your select.

Questions about posting. See faq183-874