SQL logical operator
select * from table where Condition1 or Condition2 and Condition3
这条语句的执行结果是哪个?
1select * from table where (Condition1 or Condition2) and Condition3
2select * from table where Condition1 or (Condition2 and Condition3)
--------------------------------------------------------------------------
KEY:2
Note:
priority sequence descendingly is :not and or .
這樣的問題答案應該 2 。
这条语句的执行结果是哪个?
1select * from table where (Condition1 or Condition2) and Condition3
2select * from table where Condition1 or (Condition2 and Condition3)
--------------------------------------------------------------------------
KEY:2
Note:
priority sequence descendingly is :not and or .
這樣的問題答案應該 2 。
test my signature
posted on 2008-03-12 18:47 NextStep-V 阅读(218) 评论(0) 收藏 举报
浙公网安备 33010602011771号