Select all records from emp table where deptno = 10 or 40.
SELECT * FROM emp WHERE deptno = 10 OR deptno = 40;