Analytics Software

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!

MAX keep dense function

user1175345Mar 1 2010 — edited Mar 1 2010

Hi Everyone,

Rod West explained to me about MAX keep dense here:

1037129

I have another query to do that could use MAX, so tried this:

MAX(Status) KEEP(DENSE_RANK LAST ORDER BY ID||Status )

I want the max status for a student (where a student can have mutiple records with multiple status values)

I am getting an error:
ora 001722 - invalid number.

the status is an alpha field....

Did i code the max function correctly?

pls advise, thx, sandra

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 29 2010

Added on Mar 1 2010

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

6 comments

2,742 views