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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment