OPERATOR PRECEDENCE   Let’s list the employees which JOB_ID is SA_REP or AD_PRES , and have salary more than 15000. SELECT first_name,last_name, job_id, salary FROM hr.employees WHERE job_id = ‘SA_REP‘ OR job_id = ‘AD_PRES‘ AND salary > 15000;   This way, all employess which JOB_ID is SA_REP listed as result. We need to add parenthesis … Continue reading Oracle SQL Tutorials – Chapter 2 (Part 3 of 3)