Oracle版本升级变化问题

[听雨停了]

SELECT CASE  WHEN RESULT = 'FAIL' THEN 'NG;THE SN IN Apple FG OBA LAST TEST RECODE IS NOT PASS'
            ELSE 'OK' END RESULT
FROM
(
    SELECT SN,NVL(MAX(RESULT),'PASS') AS RESULT  FROM 
    (
          SELECT A.SN,A.RESULT,
            ROW_NUMBER() OVER (PARTITION BY A.SN ORDER BY A.INTIME DESC) RN
        FROM SAJET.M_NITESTRECORD_T A  
        WHERE A.SN = '1233' AND A.TEST_STATION_NAME ='TEST'
    )
    WHERE RN=1
);

此SQL在11g可以运行，19C不行，按我的理解11g应该也不行啊，max的时候不需要group by的吗，求大神帮忙解答