Oracle Database Discussions

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!

LAG analytic function

702665Mar 18 2010 — edited Mar 18 2010

Hi there,

The LAG analytic function returns values from a previous row in the table. The first row with the previous result set is always NULL.
Is there a way to the values in that row?

STATE_ID         PREVIOUS_STATE         
---------------------- ---------------------- 
1                      NULL      <---------------  How could we get value in this cell too?                 
3                      1                      
1                      3                      
3                      1                      
1                      3                      
3                      1                      
1                      3                      
3                      1                      

8 rows selected

Thansk and regards,
Indhu

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2010

Added on Mar 18 2010

#general-database-discussions

8 comments

1,275 views