OR Operator
In the OR operator If either of the conditions evaluates to TRUE it returns TRUE value. Or else it will return FALSE.
Example
SELECT * FROM emp WHERE deptno=10 OR deptno=20;
This display would be as follows:
The instance example for displays records of all the employees where the deptno is either 10 or 20.