Skip to Main Content
Forums

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!

Lead function query unable to populate last record

1004386Jun 3 2013 — edited Jun 3 2013
hi,

select item_no, first_date as first_date, lead(first_date, 1) over(partition by item_no order by first_date) as second_date
from table1

I am able to populate all records but last record(second_date) shows as null. But i want to populate it to second_date.

Thanks for your help in advance.
This post has been answered by jeneesh on Jun 3 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2013
Added on Jun 3 2013
#plsql, #query, #sql
9 comments
183 views