Home » SQL & PL/SQL » SQL & PL/SQL » partition by rownum - clarify (oracle 9i)
partition by rownum - clarify [message #399553] Wed, 22 April 2009 22:44 Go to next message
Messages: 16
Registered: May 2006
Junior Member
Can someone please explain me what it does "max(rownum) over (partition by rownum - level" in the solution suggested in teh following link?
select ... from (select ..., rownum as rn, max(rownum) over (partition by rownum - level) as leaf_rn from ...) where rn = leaf_rn in the link : http://forums.oracle.com/forums/thread.jspa?messageID=1956369&

Re: partition by rownum - clarify [message #399564 is a reply to message #399553] Thu, 23 April 2009 00:45 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
What testcase did you create to view its behavior?
Previous Topic: how to set 'sessions_per_user' ?
Next Topic: Alias in ORDER BY
Goto Forum:

Current Time: Tue Aug 22 17:51:06 CDT 2017

Total time taken to generate the page: 0.07666 seconds