select
A.MO_NUMBER,
sum(decode(A.GROUP_NAME , 'PACKING', 1)) PACKING,
sum(decode(A.GROUP_NAME, 'MAC INPUT', 1)) MAC_INPUT,
sum(decode(A.GROUP_NAME, 'FT2', 1)) FT2,
sum(decode(A.GROUP_NAME, 'AOI II', 1)) AOI_II,
sum(decode(A.GROUP_NAME, 'MAC COMPARE', 1)) MAC_COMPARE,
sum(decode(A.GROUP_NAME, 'ASY-1', 1)) ASY_1,
sum(decode(A.GROUP_NAME, 'VISUAL INSPECT', 1)) VISUAL_INSPECT
from
SFISM4.R_WIP_TRACKING_T a
where A.MO_NUMBER='005700000405-1'
group by A.MO_NUMBER, A.GROUP_NAME
A.MO_NUMBER,
sum(decode(A.GROUP_NAME , 'PACKING', 1)) PACKING,
sum(decode(A.GROUP_NAME, 'MAC INPUT', 1)) MAC_INPUT,
sum(decode(A.GROUP_NAME, 'FT2', 1)) FT2,
sum(decode(A.GROUP_NAME, 'AOI II', 1)) AOI_II,
sum(decode(A.GROUP_NAME, 'MAC COMPARE', 1)) MAC_COMPARE,
sum(decode(A.GROUP_NAME, 'ASY-1', 1)) ASY_1,
sum(decode(A.GROUP_NAME, 'VISUAL INSPECT', 1)) VISUAL_INSPECT
from
SFISM4.R_WIP_TRACKING_T a
where A.MO_NUMBER='005700000405-1'
group by A.MO_NUMBER, A.GROUP_NAME
select
A.MO_NUMBER,
sum(decode(A.GROUP_NAME , 'PACKING', 1)) PACKING,
sum(decode(A.GROUP_NAME, 'MAC INPUT', 1)) MAC_INPUT,
sum(decode(A.GROUP_NAME, 'FT2', 1)) FT2,
sum(decode(A.GROUP_NAME, 'AOI II', 1)) AOI_II,
sum(decode(A.GROUP_NAME, 'MAC COMPARE', 1)) MAC_COMPARE,
sum(decode(A.GROUP_NAME, 'ASY-1', 1)) ASY_1,
sum(decode(A.GROUP_NAME, 'VISUAL INSPECT', 1)) VISUAL_INSPECT
from
SFISM4.R_WIP_TRACKING_T a
where A.MO_NUMBER='005700000405-1'
group by A.MO_NUMBER
繼續請教
SELECT
A.MO_NUMBER,
SUM (decode(A.GROUP_NAME , 'PTH INPUT', A.PASS_QTY )) INPUT_QTY,
SUM (decode(A.GROUP_NAME , 'ICT', A.PASS_QTY )+ decode(A.GROUP_NAME , 'ICT1', A.PASS_QT) + decode(A.GROUP_NAME , 'ICT3', A.PASS_QTY) )OUTPUT_QTY,
SUM (decode(A.GROUP_NAME , 'PRESS FIT', A.PASS_QTY )) PRESS_FIT,
SUM (decode(A.GROUP_NAME , 'VISUAL INSPECT', A.PASS_QTY )) VISUAL_INSPECT,
SUM (decode(A.GROUP_NAME , '5D XRAY', A.PASS_QTY )) D_XRAY
FROM SFISM4.R_STATION_REC_T A
WHERE A.MO_NUMBER='005700000351-1'
group by A.MO_NUMBER第二段Decode 怎麼才能算出來,現在算是為空的
decode(A.GROUP_NAME , 'ICT', A.PASS_QTY, 'ICT1', A.PASS_QT, 'ICT3', A.PASS_QTY)
SELECT
A.MO_NUMBER,
sum (
nvl(decode(A.GROUP_NAME , '5D XRAY', A.PASS_QTY , 'VISUAL INSPECT',A.PASS_QTY),0)/
(nvl(decode(A.GROUP_NAME , '5D XRAY', A.PASS_QTY , 'VISUAL INSPECT',A.PASS_QTY),0)
/ nvl(decode(A.GROUP_NAME , '5D XRAY', A.FAIL_QTY , 'VISUAL INSPECT',A.FAIL_QTY),0))
) Yiled_Rate
FROM SFISM4.R_STATION_REC_T A
WHERE A.MO_NUMBER='005700000005-1'
group by A.MO_NUMBER
不知這段代碼放在上面那段里面怎麼樣才行得通,或者有別的方法,求教!!!!
select round( ((62- 4)/62)*100,2) aa from dual 這是要的結果
SELECT
A.MO_NUMBER,
sum (
nvl(decode(A.GROUP_NAME , '5D XRAY', A.PASS_QTY , 'VISUAL INSPECT',A.PASS_QTY),0)/
(nvl(decode(A.GROUP_NAME , '5D XRAY', A.PASS_QTY , 'VISUAL INSPECT',A.PASS_QTY),0)
/ nvl(decode(A.GROUP_NAME , '5D XRAY', A.FAIL_QTY , 'VISUAL INSPECT',A.FAIL_QTY),0))
) Yiled_Rate
FROM SFISM4.R_STATION_REC_T A
WHERE A.MO_NUMBER='005700000005-1'
group by A.MO_NUMBER
不知這段代碼放在上面那段里面怎麼樣才行得通,或者有別的方法,求教!!!!
select round( ((62- 4)/62)*100,2) aa from dual 這是要的結果
啥意思?没看懂
例如:select round( ((62- 4)/62)*100,2) aa from dual
在SUM (Decode,.,.,.)中可以運算出來不
SELECT
A.MO_NUMBER,
sum (
nvl(decode(A.GROUP_NAME , '5D XRAY', A.PASS_QTY , 'VISUAL INSPECT',A.PASS_QTY),0)/
(nvl(decode(A.GROUP_NAME , '5D XRAY', A.PASS_QTY , 'VISUAL INSPECT',A.PASS_QTY),0)
/ nvl(decode(A.GROUP_NAME , '5D XRAY', A.FAIL_QTY , 'VISUAL INSPECT',A.FAIL_QTY),0))
) Yiled_Rate
FROM SFISM4.R_STATION_REC_T A
WHERE A.MO_NUMBER='005700000005-1'
group by A.MO_NUMBER
不知這段代碼放在上面那段里面怎麼樣才行得通,或者有別的方法,求教!!!!
select round( ((62- 4)/62)*100,2) aa from dual 這是要的結果
啥意思?没看懂第二個/ 號就-號,打錯了