| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.oracle -> Query Help
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 60Received on Tue May 18 2004 - 12:21:13 CDT
![]() |
![]() |