Tuesday, June 21, 2011

previous not null values of a field in oracle

select lastprice, lag(lastprice ignore nulls,1) over (order by statdate) from daily_statistics

No comments: