SQL拼接
SQL1:
select SUM(CASE WHEN UNDESIRABLE != ' ' THEN 1 END) from Tm_Marketfeedback
WHERE datetochar(BACKDATE,'M') BETWEEN '2009-05' AND '2012-06')
SQL2:
select SUM(LOT_SIZE) AS B from tl_out_lot
where datetochar(OUTGOINGDATE,'M') ='2012-06'
将两条SQL的值相除 整合一条SQL，谢谢~~
[解决办法]
select (select SUM(CASE
WHEN UNDESIRABLE != ' ' THEN
1
END)
from Tm_Marketfeedback
WHERE datetochar(BACKDATE, 'M') BETWEEN '2009-05' AND '2012-06')) /
(select SUM(LOT_SIZE) AS B
from tl_out_lot
where datetochar(OUTGOINGDATE, 'M') = '2012-06')
from dual;
