butterluo的博客

/*tested in oracle*/ /* you can use select statment in then clause*/ SELECT CASE bh.zajlx WHEN '2' THEN (SELECT qt1.sfdb FROM t03_qtajxx qt1 ...

/*日期的操作包含在子查询中，oracle测试通过*/ SELECT count(*), c.lrr_dm FROM jc_ajxx c WHERE c.jczt_dm IN ('01', '02', '10') and c.ajbh in (select c...

[code] SELECT cq.ayxsbh, cq.process_ins_id, nsr.nsrsbh, nsr.nsrmc, jg.swjg_mc FROM t03_cqzb cq, t03_ayxsqc ay, dm_swjg jg, dj_nsrxx nsr WHERE cq.process_ins_id = 2991 AND SYSDATE > cq.jzrq ...

[code] /* Formatted on 2007/12/20 18:12 (Formatter Plus v4.8.8) */ SELECT * FROM (SELECT w.workitem_id, w.m_id, w.process_def_id, w.process_def_...

[code] SELECT * FROM (SELECT a.*, ROWNUM row_num FROM (SELECT t1.ajbh, t1.lrajbh, t2.nsrsbh, t2.nsrmc, t4.swjg_mc, t5.jczt_mc, CASE...

[code] --当该人是选案人员时 select qt.ajbh, qt.lrajbh, nsr.nsrsbh, nsr.nsrmc, jg.swjg_mc, zt.jczt_mc, qt.sfla from ctais2wg.t03_qtajxx qt ,ctais2wg.t03_ayxsqc ay ,ctais2wg.dm_jczt zt ,ctai...