selectA.LOTID,SUM(DECODE(A.LINE,'BML',A.TIMES))ASBML,SUM(DECODE(A.LINE,'BLU',A.TIMES))ASBLU,SUM(DECODE(A.LINE,'GRN',A.TIMES))ASGRN,SUM(DECODE(A.LINE,'RED',A.TIMES))ASRED,...
select A.LOTID,
SUM(DECODE(A.LINE, 'BML', A.TIMES)) AS BML,
SUM(DECODE(A.LINE, 'BLU', A.TIMES)) AS BLU,
SUM(DECODE(A.LINE, 'GRN', A.TIMES)) AS GRN,
SUM(DECODE(A.LINE, 'RED', A.TIMES)) AS RED,
SUM(DECODE(A.LINE, 'RPL', A.TIMES)) AS RPL,
SUM(DECODE(A.LINE, 'OCL', A.TIMES)) AS OCL,
SUM(DECODE(A.LINE, 'IAL', A.TIMES, 'IBL', A.TIMES)) AS ITO,
SUM(DECODE(A.LINE, 'ANL', A.TIMES)) AS ANL,
SUM(DECODE(A.LINE, 'PSL', A.TIMES)) AS PSL,
SUM(DECODE(A.LINE, 'FIL', A.TIMES)) AS FIL
from (select t.oper_id AS LINE,
substr(t.lot_id, 1, 3) as LOTID,
(to_date(t.end_timestamp, 'yyyy-mm-dd hh24:mi:ss') -
to_date(t.start_timestamp, 'yyyy-mm-dd hh24:mi:ss')) * 24 * 60 AS TIMES
from report.st_abnormal t
where error_second_code in ('N002', 'B001', 'B002')
and t.txn_date >= '2014-03-01'
and t.txn_date < = '2014-03-31') A
GROUP BY A.LOTID
如何对已求出的BML,BLU,GRN,RED,RPL,OCL,ITO,ANL,PSL,FIL再求和!!!
展开