order by ) 中的order by 要删掉。
select issue_id,proposer_name,issue_date,station,line,model,badness,phenomenon,estimated,PRONCIPAL_NAME,CLOSURE,CLOSURE_TIME,UPDATE_TIME from cus_mis_issue_head where not exists (select issue_id,proposer_name,issue_date,station,line,model,badness,phenomenon,estimated,PRONCIPAL_NAME,CLOSURE,CLOSURE_TIME,UPDATE_TIME from cus_mis_issue_head where rownum <=5 ) and rownum <=5 order by closure asc;
这么明显,括号前面那个order by 明显多打了么