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')
搜索
复制
标签:Status,GOODS,17,区别,BID,sqlserver,WAIT From: https://www.cnblogs.com/jankie1122/p/11108830.html