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!

Find the previous records of max record

user10069916Dec 19 2012 — edited Dec 19 2012

Dear sir,

ID Date Ind
2222 11/01/2006
1111 13/01/2006
1111 12/01/2006
3333 14/01/2006 Y

here ind ='Y' record is
3333 14/01/2006

my requirement is
1111 12/01/2006

just previous record of ind='Y'

Please help me.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2013

Added on Dec 19 2012

19 comments

318 views