Question

用extjs做出的查询，提示 “缺少右括号” 错误，但是sql语句在plsql里是没有错误的

，语句如下：@"select * from (select t.*,rownum rn from ( select a.cb, a.jh, b.nf, (YBCLCB_SK+RLF_SK+YF_SK) as skcb, (YBCKCB_ZY+RLF_ZY+YF_ZY) as zycb, b.qtcb, a.csfs, a.lrrq from skgysjb a,hs_qtcbwhb b where a.lrrq=b.nf {0} )t {1} ) Where rn between {2} and {3}";

Answer 1

：@"select * from (select t.*,rownum rn from ( select a.cb, a.jh, b.nf, (YBCLCB_SK+RLF_SK+YF_SK) as skcb, (YBCKCB_ZY+RLF_ZY+YF_ZY) as zycb, b.qtcb, a.csfs, a.lrrq from skgysjb a,hs_qtcbwhb b where a.lrrq=b.nf {0} )t {1} ) Where rn between {2} and {3}"); 最後少了一个括弧