这个问题怎么解决啊,高手帮忙啊!
有条SQL如下:
select Distinct WorkPhase '制程', ModelNo '机种', BoardOfFiner '检验总数', BoardOfBad '不良数', (BoardOfFiner * CheckNum) '检验总点数',BCheckNadd '不良点数',Cast((BoardOfBad * 100.00/BoardOfFiner) as decimal(10,2 )) '不良率(%)',Cast(100-(BoardOfBad * 100.00/BoardOfFiner) as decimal(10,2 )) '直通率(%)',Cast(BCheckNadd * 1000000/(BoardOfFiner * CheckNum) as decimal(10,2)) 'DPPM' from tmp_ResultOfRate where WorkPhase <> 'PCK' Group by WorkPhase,ModelNo,BoardOfFiner,BoardOfBad,CheckNum,BCheckNadd
跑出的结果如下:
SMT BD336021LF(FX5200) 332 1 122840 1 .30 99.70 8.00
SMT BD349320LF(GF6200TC) 2539 16 952125 19 .63 99.37 19.00
SMT BD3598 1335 10 640800 15 .75 99.25 23.00
SMT BD359821LF(GF7100GS) 7 0 3360 NULL .00 100.00 NULL
SMT BD359821LF(GF7100GS) 69 0 33120 NULL .00 100.00 NULL
SMT BD359821LF(GF7100GS) 650 21 312000 31 3.23 96.77 99.00
SMT BD359821LF(GF7100GS) 1532 7 735360 9 .46 99.54 12.00
SMT BD363810LF(GF7300GT) 1 0 808 NULL .00 100.00 NULL
TET BD349320LF(GF6200TC) 703 4 11248 4 .57 99.43 355.00
TET BD357220LF(ATIX1300LE) 10 1 100 1 10.00 90.00 10000.00
TET BD359810LF(GF7300LE) 1 0 11 NULL .00 100.00 NULL
TET BD359810LF(GF7300LE) 2 2 22 3 100.00 .00 136363.00
TET BD359810LF(GF7300LE) 6 0 66 NULL .00 100.00 NULL
TET BD359810LF(GF7300LE) 27 3 297 5 11.11 88.89 16835.00
TET BD359810LF(GF7300LE) 94 1 1034 1 1.06 98.94 967.00
TET BD359821LF 103 1 1133 NULL .97 99.03 NULL
TET BD359821LF 158 1 1738 1 .63 99.37 575.00
TET BD359821LF(GF7100GS) 1 0 11 NULL .00 100.00 NULL
TET BD359821LF(GF7100GS) 1 1 12 3 100.00 .00 250000.00
TET BD359821LF(GF7100GS) 2 2 24 6 100.00 .00 250000.00
TET BD359821LF(GF7100GS) 31 5 341 8 16.13 83.87 23460.00
TET BD359821LF(GF7100GS) 40 0 480 NULL .00 100.00 NULL
TET BD359821LF(GF7100GS) 1783 7 19613 7 .39 99.61 356.00
TET BD359821LF(GF7100GS) 3650 24 40150 17 .66 99.34 423.00
TET BD363810LF(GF7300GT) 2 0 26 NULL .00 100.00 NULL
TET BD363810LF(GF7300GT) 7 1 91 1 14.29 85.71 10989.00
但是这个结果不是我想要的,怎么样才能把第二列" ModelNo '机种'"重复的项合并!后面几列中的数据也累加进去.怎么改这个SQL啊!