SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Understanding sum() over(order by) analytic function

Activesometimes-OracleMay 20 2013 — edited May 20 2013

Could you please explain Having_order_by column values computation for below query?
I understand that No_Partition column has been computed over entire result set

select level
,sum(level) over(order by level) Having_order_by
,sum(level) over() No_Partition
from dual 
connect by level < 6

This post has been answered by Frank Kulash on May 20 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2013

Added on May 20 2013

2 comments

338 views