已解決430363個問題，去搜搜看，總會有你想問的

not in 效率低，怎么把not in 給替換掉

首頁猿問 not in 效率低，怎么把not...

not in 效率低，怎么把not in 給替換掉

SQL Server

幕布斯6054654 2018-12-06 21:50:11

SELECT sp.* FROM Prc_SalePolicy sp WHERE sp.UseState=1 AND sp.AccId=3103 AND sp.Prc_SPId NOT IN (SELECT Prc_SPId FROM Prc_CustSetSP WHERE Fin_AccDtId=123425430000004) not in 效率低，怎么把not in 給替換掉？

查看完整描述

2 回答

largeQ

TA貢獻2039條經驗獲得超8個贊

SELECT sp.* FROM Prc_SalePolicy sp 
left join Prc_CustSetSP  pc on sp.Prc_SPId  =pc.Prc_SPId 
WHERE  
sp.UseState=1 
AND sp.AccId=3103 
AND Fin_AccDtId!=123425430000004)
SELECT sp.* FROM Prc_SalePolicy sp 
left join Prc_CustSetSP  pc on sp.Prc_SPId  =pc.Prc_SPId 
WHERE  
sp.UseState=1 
AND sp.AccId=3103 
AND Fin_AccDtId<123425430000004)
union
SELECT sp.* FROM Prc_SalePolicy sp 
left join Prc_CustSetSP  pc on sp.Prc_SPId  =pc.Prc_SPId 
WHERE  
sp.UseState=1 
AND sp.AccId=3103 
AND Fin_AccDtId>123425430000004)

反對回復 2019-01-07

慕容森

TA貢獻1853條經驗獲得超18個贊

SELECT sp.* FROM Prc_SalePolicy sp
WHERE
sp.UseState=1
AND sp.AccId=3103
AND NOT EXISTS(SELECT 1 FROM Prc_CustSetSP pc WHERE pc.Prc_SPId = sp.Prc_SPId AND Fin_AccDtId=123425430000004)

反對回復 2019-01-07

2 回答
0 關注
848 瀏覽

關注

添加回答

舉報

0/150

提交

取消

亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

熱搜

最近搜索清空

not in 效率低，怎么把not in 給替換掉

not in 效率低，怎么把not in 給替換掉

2 回答

添加回答

not in 效率低，怎么把not in 給替換掉