下面这句sql语句提示缺失右括号,请大家帮下忙

2025-01-01 14:56:02
推荐回答(2个)
回答1:

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;

回答2:

这么明显,括号前面那个order by 明显多打了么