求解SQL 如何多条件筛选？

求解SQL 如何多条件筛选？

试试：
select A.storets as sjstorets, A.processts, A.wafer, A.row, A.col, A.htnum, A.statnum, A.site, A.op as opnum,
A.jobnum, A.carrier, A.employee, A.ec as fabec, a.sh as PreFCLSH,
(case when A.htnum in (42,47) then (A.SH>0.7 and A.sh<1.5),
when A.htnum in (43) then (A.SH>0.55 and A.sh<1.3),
when A.htnum in (44) then (A.SH>0.5 and A.sh<1.3),
when A.htnum in (45) then (A.SH>1.1 and A.sh<2.0),
when A.htnum in (46) then (A.SH>0.4 and A.sh<1.0),
when A.htnum in (39.40.41) then (A.SH>0.7 and A.sh<1.5)
end)
from FAB.OP2365 A where A.op=8365 and A.site='SZ'
order by A.wafer,A.row,A.col追答按照你的要求，用case实现不了，你还是用union吧
select A.storets as sjstorets, A.processts, A.wafer, A.row, A.col, A.htnum, A.statnum, A.site, A.op as opnum,
A.jobnum, A.carrier, A.employee, A.ec as fabec, a.sh as PreFCLSH from FAB.OP2365 A where A.op=8365 and A.site='SZ'
and A.htnum in (42,47) and (A.SH>0.7 and A.sh<1.5) order by A.wafer,A.row,A.col
union
select A.storets as sjstorets, A.processts, A.wafer, A.row, A.col, A.htnum, A.statnum, A.site, A.op as opnum,
A.jobnum, A.carrier, A.employee, A.ec as fabec, a.sh as PreFCLSH from FAB.OP2365 A where A.op=8365 and A.site='SZ'
and A.htnum in (43) and (A.SH>0.55 and A.sh<1.3) order by A.wafer,A.row,A.col
union
.....