Skip to Main Content

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 max value from multiple row

Jeffy DwitraNov 2 2016 — edited Nov 2 2016

Hi guys I've a table with the value like this :

10.PNG

I want to find the max value progress based on job execution id, I've try use query like this :

SELECT MAX(PROGRESS),

   JOB\_EXECUTION\_ID

FROM PM_JOB_EXECUTION_DETAILS

GROUP BY JOB_EXECUTION_ID;

But when I compile, it become like this :

11.PNG

job execution id = 491 should have a value 100 not 20, please help me to solve my solution.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2016
Added on Nov 2 2016
5 comments
5,148 views