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!

Lag Function ignoring nulls in 10g

1061105Dec 18 2013 — edited Dec 18 2013

I have the following Query which is working well in 11g. I want to rewrite the query in 10g and get the same result set. Since lag ignoring nulls I used below is a new feature in 11g, can someone help me in rewriting the query below.

Prop1 - String, evar11 - String

select prop1, evar11,

	lag(prop1 ignore nulls) over ( partition by visid_high, visid_low,visit_num, period_key order by visit_page_num) as prop1_lag
	from TABLE_A

where period_key = '20131012' -- DATE

order by visit_page_num

Thanks in Advance,

This post has been answered by Frank Kulash on Dec 18 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2014

Added on Dec 18 2013

2 comments

625 views