where 语句 同时包含 or 和and这种怎么弄

2025-03-26 02:28:53
推荐回答(2个)
回答1:

没有用 括号的情况下, and优先 where a>b or a>c and a>d 等价于 where a>b or (a>c and a>d) 如果想要先计算or where (a>b or a>c) and a>d

回答2:

where (A or B) and C