OR and MoreThan (>) operator
Script :

Select empno, ename, sal , job FROM EMP where job ='MANAGER' OR SAL > 1500

Oracle EMP table
Oracle :

 

PostgreSQL