Hello team,
I am thinking during this Corona pandemic:
What happens in the world of database engine if we have OR in our where clause with equal criteria? Will we have 2 rows be back in the result set?
Respectfully,
BittenApple
OR(1,1) - equal criteria
-
HansV
- Administrator
- Posts: 78448
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: OR(1,1) - equal criteria
No, it will not lead to duplication of records in the result set.
Best wishes,
Hans
Hans
-
BittenApple
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: OR(1,1) - equal criteria
Wow!
Great response.
Having said that, as soon as it meets the criteria in OR, it skip second argument.
Respectfully,
BittenApple
Great response.
Having said that, as soon as it meets the criteria in OR, it skip second argument.
Respectfully,
BittenApple