Question

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

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 order by ) and rownum <=5 order by closure asc;

数遍问一句，Oracle的not exists用对了吗？
最后行，前面的order by 应该是 order by closure asc)

Answer 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;

Answer 2

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

追问

...失误失误，原句是order by closure asc) 测试的时候没删干净....