UC知道救命啊！这段sql不理解，快被搞死了
来源：百度知道 编辑：UC知道 时间：2024/06/14 18:26:27
我不知道 sql sql1 sql2怎么理解
他们是互相调用的吗？如果是又是怎样互相调用的
我就想问下 sql sql1 sql2 是如何互相调用的
StringBuffer sql = new StringBuffer();
StringBuffer sql1 = new StringBuffer();
StringBuffer sql2 = new StringBuffer();
sql.append(" select dwdm,mc,bh,hh,hm,rdl,sydl,ycxx from ( ");
sql1.append(" select count(*) from (");
sql2.append(" select a.dw dwdm, ( select b.jldmc from y_gkjldxx b where b.jldbh = a.jldbh union select c.jldmc from y_jlzz c where not exists(select jldmc from y_gkjldxx y where y.jldbh=c.jldbh) and c.jldbh = a.jldbh) mc, ");
sql2.append(" a.hh,a.hm,a.jldbh bh, ");
sql2.append(" (select d.sjz from q_daydata d where d.jldbh=a.jldbh and d.sjxdm='9010' and d.sssj=to_date('"+searchDate+"','yyyy-MM-dd')) rdl, ");
sql2.append(" (select sum(e.sjz) from q_daydata e where e.jldbh=a.jldbh and e.sjxdm='9010' and e.sssj like '
他们是互相调用的吗？如果是又是怎样互相调用的
我就想问下 sql sql1 sql2 是如何互相调用的
StringBuffer sql = new StringBuffer();
StringBuffer sql1 = new StringBuffer();
StringBuffer sql2 = new StringBuffer();
sql.append(" select dwdm,mc,bh,hh,hm,rdl,sydl,ycxx from ( ");
sql1.append(" select count(*) from (");
sql2.append(" select a.dw dwdm, ( select b.jldmc from y_gkjldxx b where b.jldbh = a.jldbh union select c.jldmc from y_jlzz c where not exists(select jldmc from y_gkjldxx y where y.jldbh=c.jldbh) and c.jldbh = a.jldbh) mc, ");
sql2.append(" a.hh,a.hm,a.jldbh bh, ");
sql2.append(" (select d.sjz from q_daydata d where d.jldbh=a.jldbh and d.sjxdm='9010' and d.sssj=to_date('"+searchDate+"','yyyy-MM-dd')) rdl, ");
sql2.append(" (select sum(e.sjz) from q_daydata e where e.jldbh=a.jldbh and e.sjxdm='9010' and e.sssj like '
sql2是一个复杂的字查询。
sql是查询这个复杂字查询中的某些字段值；
sql1是查询这个复杂字查询共有多少条。
StringBuffer 的 append方法就是字符串向加啊。
太长了，你执行一下看看最后的 sql sql1 sql2 是什么值
gdnjhn