SQLSERVER語句 in和exists哪個效率高本人測試證明
SQLSERVER語句 in和exists哪個效率高本人測試證明?
LEATH
2018-10-24 10:06:30
1 回答
慕斯709654
TA貢獻1840條經驗 獲得超5個贊
例如下面兩個SQL語句
1 SELECT OrderNo, SiteCode, AreaCode
2 FROM SchedulingProgram
3 WHERE AreaCode IN ( 'P', 'M' ) AND SiteCode IN ( SELECT SiteCode
4 FROM EnvBasicInfo
5 WHERE cityiD = 31 ) AND OrderNo NOT IN (
6 SELECT OrderNo
7 FROM KK_DeliveryinfoTmp )
上面SQL語句IN里面有IN和NOT IN
1 SELECT OrderNo, SiteCode, AreaCode
- 1 回答
- 0 關注
- 677 瀏覽
添加回答
舉報
0/150
提交
取消