0

Filter Conditions between 2 fields

Hi there,
I understand that adding on filter conditions at the back of the NL funcion is actually using the "AND" condition.
SQL Example:
SELECT name, address FROM student WHERE contactNo="1234567" AND gender="Male";

How do i use the "OR" condition?
SQL Example:
SELECT name, address FROM student WHERE contactNo="1234567" OR gender="Male";

Thanks in advance.

1 comment

Please sign in to leave a comment.