(word)Oracle With 语句语法及示例.docVIP

Oracle With 语句语法及示例Oracle With 语句实例： insert into sms_tmp_stop_circlenum_zsdx –将下面查询的结果插入到临时表中 WITH selectdata -- Oracle With开始的查询语句 AS SELECT TRUNC createtime senddate,agentid,srcnum, ROUND SUM CASE WHEN result 4 THEN 1 ELSE 0 END /COUNT * *100,2 AS ratio FROM ZSDX_SMS_OTHERSEND_DETAILS WHERE agentid LIKE zsdx% AND createtime TO_DATE 2010-12-30 00:00:00,yyyy-mm-dd hh24:mi:ss AND createtime TO_DATE 2010-12-30 23:59:59,yyyy-mm-dd hh24:mi:ss GROUP BY TRUNC createtime ,srcnum,agentid SELECT a2.senddate,a1.agentid,a1.srcnum,a1.passwd,a1.ACCOUNT,a1.createtime,a2.ratio||% AS 当天状态返回失败比率,SY