The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

ORACLE
(SELECT STATUS FROM (SELECT * FROM A_RESULT ORDER BY PERCENTAGE_SCORE DESC) WHERE SESSION_MID = S_CLUSTER_ASSESSMENT.SESSION_MID AND SESSION_LID = S_CLUSTER_ASSESSMENT.SESSION_LID AND PARTICIPANT = G_PARTICIPANT.PARTICIPANT_NAME AND ROWNUM = 1) AS STATUS


MS SQL
(SELECT TOP 1 STATUS FROM (SELECT TOP 100 PERCENT * FROM A_RESULT ORDER BY PERCENTAGE_SCORE DESC) AS STATUS WHERE SESSION_MID = S_CLUSTER_ASSESSMENT.SESSION_MID AND SESSION_LID = S_CLUSTER_ASSESSMENT.SESSION_LID AND PARTICIPANT = G_PARTICIPANT.PARTICIPANT_NAME) AS STATUS