SerilCode Model Station Status Error
FM03FF-86081103AD01N00001 FM03FF-86 FQC測試 FAIL B001
FM03FF-86081103AD01N00003 FM03FF-86 FQC測試 FAIL B002
FM03FF-86081103AD01N00006 FM03FF-86 調焦測試 FAIL B002
FM03FF-86081103AD01N00006 FM03FF-86 FQC測試 FAIL B002查询每一站Error明细及对应数量:
结果:
FQC測試 B001 1
FQC測試 B002 2
調焦測試 B002 1
请问查询语句要怎么写?
FM03FF-86081103AD01N00001 FM03FF-86 FQC測試 FAIL B001
FM03FF-86081103AD01N00003 FM03FF-86 FQC測試 FAIL B002
FM03FF-86081103AD01N00006 FM03FF-86 調焦測試 FAIL B002
FM03FF-86081103AD01N00006 FM03FF-86 FQC測試 FAIL B002查询每一站Error明细及对应数量:
结果:
FQC測試 B001 1
FQC測試 B002 2
調焦測試 B002 1
请问查询语句要怎么写?
from ta
group by Station, Error
from tb
group by Station,Error