我要選擇以下是否匹配
Exit = 'OUT' and Status = 'SUCC' or 'ACPT'
Exit = 'IN' and Status = 'SUCC' or 'ACPT' or 'PEND
記錄：
ID|Exit |Status
1 |OUT |SUCC
2 |OUT |ACPT
3 |OUT |PEND
4 |IN |PEND
5 |IN |SUCC
6 |IN |ACPT
我想要的結果：
ID|Exit |Status
1 |OUT |SUCC
2 |OUT |ACPT
4 |IN |PEND
5 |IN |SUCC
6 |IN |ACPT
我現在這樣做：
SELECT * FROM table WHERE Status = 'PEND' or Status = 'SUCC' or Status = 'ACPT'
uj5u.com熱心網友回復：
嘗試paranthesis：
SELECT *
FROM your_table
WHERE (Exit ='OUT' AND Status IN('SUCC','ACPT'))
OR (Exit ='IN' AND Status IN('SUCC','ACPT', 'PEND'))
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/389912.html
標籤：sql