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

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 :

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