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} "; 追问： 已经解决，虽然不是括号问题，不过还是谢谢了