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!

Value before MAX

Pubudu AttygallaMay 11 2011 — edited May 11 2011

Hi,

I want to get a result like below example..

Say there are several values for a given user id.
Say user id 1 have values 1255 , 1289 , 1356 , 2050

I want to get the value just before MAX value. in above case i want result as 1356.

Is there anyway to do that in Oracle?

Thanks!!

Pubudu

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 8 2011

Added on May 11 2011

10 comments

665 views