22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT ISNULL(t1.LOTID, t2.LOTID) LOTID,
t1.FAIL, t1.[MIN], t1.[MAX],
t2.FAIL, t2.[MIN], t2.[MAX]
FROM (SELECT * FROM table1 WHERE PARAMETER='T10_ISGS_35.0V_9.90mA') t1
FULL JOIN (SELECT * FROM table1 WHERE PARAMETER='T10_ISGS_45.0V_9.90mA') t2
ON t1.LOTID = t2.LOTID
select r1.LOTID,r1.[T10_ISGS_35.0V_9.90mA],FAILt1,MINt1,MAXt1
,r1.[T10_ISGS_45.0V_9.90mA],FAILt2,MINt2,MAXt2
from (select LOTID,max([T10_ISGS_35.0V_9.90mA]) [T10_ISGS_35.0V_9.90mA],max([T10_ISGS_45.0V_9.90mA]) [T10_ISGS_45.0V_9.90mA] from t
pivot(max(PARAMETER) for PARAMETER in([T10_ISGS_35.0V_9.90mA],[T10_ISGS_45.0V_9.90mA])) t1
group by LOTID) r1
left join (select t1.LOTID,t1.FAIL FAILt1,t1.[MIN] MINt1,t1.[MAX] MAXt1,t2.FAIL FAILt2,t2.[MIN] MINt2,t2.[MAX] MAXt2
from t t1
left join t t2 on t1.LOTID = t2.LOTID
where t1.PARAMETER = 'T10_ISGS_35.0V_9.90mA' and t2.PARAMETER = 'T10_ISGS_45.0V_9.90mA') r2 on r1.LOTID = r2.LOTID