sqlserver and or 的区别

sqlserver and or 的区别

Or不加括号：

查询结果36条数据，BID=21，BID=25匹配的Status的数据都会查询出来

 

select BID,TradeID,[status],PaymentToBId from Trade where BID='17' 
and [Status]='WAIT_BUYER_CONFIRM_GOODS' or [Status]='WAIT_SELLER_SEND_GOODS'

 

===============================================================

Or加括号：

查询结果30条数据，只查询出BID=17匹配的Status的数据

 

select BID,TradeID,[status],PaymentToBId from Trade where BID='17' 
and ([Status]='WAIT_BUYER_CONFIRM_GOODS' or [Status]='WAIT_SELLER_SEND_GOODS')

 

搜索

复制