When using the OR Clause in sql query, what Will happened if both condition is true? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 4

When using the OR Clause in sql query, what Will happened if both condition is true?

5th Jun 2018, 11:28 PM
ABDOUL RAHIM NDANE PECHOU
ABDOUL RAHIM NDANE PECHOU - avatar
4 Answers
+ 1
in this case it will return True
7th Jun 2018, 9:53 AM
Alexandre Vasconcelos Lima
Alexandre Vasconcelos Lima - avatar
+ 1
To understand it better, binary math is the solution 0 + 0 = 0 => false or false = false 0 + 1 = 1 => false or true = true 1 + 0 = 1 => true or false = true 1 + 1 = 1 => true or true = true Best regards.
13th Jun 2018, 1:53 PM
Pablo David Quintana Erazo
Pablo David Quintana Erazo - avatar
0
Its return true. OR return false only when both conditions are false
6th Jun 2018, 11:43 AM
Mateusz Durajewski
Mateusz Durajewski - avatar
0
OR operator returns true if any of the conditions seperated by OR is true!
12th Jun 2018, 2:02 AM
Manu Jo Varghese
Manu Jo Varghese - avatar