复制SQL> selectsum(cggzl) cggzl,化策 sum(qbgzl) qbgzl from (selectcase when zlxm_mc like%2ê3?3￡1??ì2é%then gzl else 0 end cggzl, case when zlxm_mc like%?3±í?÷1ù%then gzl else 0 end qbgzl from dictmanage.dict_zl_pro b, his.pat_inpat_order_info c, pat_inpat_order_cost d where d.sfxm_id = b.zlxm_id and c.yzjl_id = d.dyzy_yzjl_id and zlxm_mc like%2???% and c.yz_zxrq >= to_date(sysdate) and c.yz_zxrq < to_date(sysdate + 1) and d.fy_status in (1, 2) and sfxm_je > 0 and c.yz_zfrq isnull and c.zylsh = :in_zylsh) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25. |
喜欢
讨厌