<div>
Try this query:<br />
<br />
This should help you out..<br />

<pre><code id="code-252829">WITH cte ( col1, date1, count1, cnt) as
(SELECT col1, date1, count1, row_number() OVER ( ORDER BY date1 ASC) cnt
FROM urtable ) 
select col1, date1, count1, cumulative from 
(
SELECT t1.col1, t1.date1, t1.count1, (SELECT sum(cte.count1) FROM cte WHERE cte.cnt &lt;= t1.cnt) cumulative
FROM cte t1) as tmp
where cumulative &lt;= 20
</code></pre>
</div>


Try this query:

This should help you out..


WITH cte ( col1, date1, count1, cnt) as
(SELECT col1, date1, count1, row_number() OVER ( ORDER BY date1 ASC) cnt
FROM urtable ) 
select col1, date1, count1, cumulative from 
(
SELECT t1.col1, t1.date1, t1.count1, (SELECT sum(cte.count1) FROM cte WHERE cte.cnt <= t1.cnt) cumulative
FROM cte t1) as tmp
where cumulative <= 20


<div>
Thanks very much for this - I think I understand the partition by statement now - until the next time :D - Great work
</div>


Thanks very much for this - I think I understand the partition by statement now - until the next time :D - Great work

<div>
glad I could help. &nbsp;analytics are definitely an awesome set of tools to learn.
</div>


glad I could help.  analytics are definitely an awesome set of tools to learn.

<div>
<div class="content wysiwyg-content">
<br />
Typical record set as follows<br />
<br />
Friend1 &nbsp; &nbsp;01/01/2009 &nbsp; &nbsp;5<br />
Friend1 &nbsp; &nbsp;03/01/2009 &nbsp; &nbsp;4<br />
Friend1 &nbsp; &nbsp;07/01/2009 &nbsp; &nbsp;6<br />
Friend1 &nbsp; &nbsp;09/01/2009 &nbsp; &nbsp;3<br />
Friend1 &nbsp; &nbsp;12/01/2009 &nbsp; &nbsp;6<br />
Friend1 &nbsp; &nbsp;13/01/2009 &nbsp; &nbsp;4<br />
<br />
Now - I want to find the first date when the accumulated timespent is equal or greater than 20. - so in the example above on 12 January the accumulated time was 24<br />
<br />
The query should then halt at 12 and move onto the next friend. <br />
<br />
Might this be done with an Analytical function? - I am using Oracle RDBMS with Data Warehousing
</div>
</div>



Typical record set as follows

Friend1    01/01/2009    5
Friend1    03/01/2009    4
Friend1    07/01/2009    6
Friend1    09/01/2009    3
Friend1    12/01/2009    6
Friend1    13/01/2009    4

Now - I want to find the first date when the accumulated timespent is equal or greater than 20. - so in the example above on 12 January the accumulated time was 24

The query should then halt at 12 and move onto the next friend. 

Might this be done with an Analytical function? - I am using Oracle RDBMS with Data Warehousing

cumulative calculation with partition by

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.