Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Query Help

Query Help

From: DM <mackdaddy315_at_hotmail.com>
Date: 18 May 2004 10:21:13 -0700
Message-ID: <bf2880e.0405180921.20de01f@posting.google.com>


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
Received on Tue May 18 2004 - 12:21:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US