I am trying to create a query to get the results below. What I want
is a query that selects for a given set of years and then totals the
amounts per year as a rolling total. I can do this by using pl/sql
using UNION for each given year. If possible would like to do this in
a sql query. If possible I am assuming I will need to use some use of
CUBE or/and ROLLUP. Any ideas???
table1
year col1
2003 10
2004 10
2005 10
2006 10
2007 10
2008 10
results:
year resultcol1
2003 10
2004 20
2005 30
2006 40
2007 50
2008 60
is a query that selects for a given set of years and then totals the
amounts per year as a rolling total. I can do this by using pl/sql
using UNION for each given year. If possible would like to do this in
a sql query. If possible I am assuming I will need to use some use of
CUBE or/and ROLLUP. Any ideas???
table1
year col1
2003 10
2004 10
2005 10
2006 10
2007 10
2008 10
results:
year resultcol1
2003 10
2004 20
2005 30
2006 40
2007 50
2008 60