Order by in the nested select statement

I’m trying to use order by clause in the nested select statement but it is giving an error ora-00907 missing paranthesis

Select a.column_name,
       (Select upper(cmnt_type) AS CMNT_TYPE
        from t_tbm_appl_comment_2015
        where appl_mnm_id=a.appl_mnm_id
           AND rownum = 1
        order by cmnt_type desc)
from MD_OTHER_OBJECTS a


Source: oracle

Leave a Reply