SELECT SUM(Price) from Table1 where ID in('58,4413,7471,7083,7085,7308,6979') 现在有个问题,In括号里的条件都要一致,如果其中一个不满足.就不查询,用In是不行的,要使用什么才能全部满足?
专业回答
不是的。in是只要有满足条件的就能查询出来。=是必须全满足。
SELECT SUM(Price) from Table1 where ID in('58,4413,7471,7083,7085,7308,6979')
相当于
SELECT SUM(Price) from Table1 where ID ='58' or id='4413' or id='7471' or id ='7083' or id='7085' or id ='7308' or id='6979')
SELECT SUM(Price) from Table1 where ID in('58,4413,7471,7083,7085,7308,6979')
相当于
SELECT SUM(Price) from Table1 where ID ='58' or id='4413' or id='7471' or id ='7083' or id='7085' or id ='7308' or id='6979')