Select all records from emp table where deptno = 30 and sal > 1500.
SELECT * FROM emp WHERE deptno = 30 AND Sal > 1500;