Monday, January 4, 2010

Example of the Precedence of the AND Operator

In the slide example, there are two conditions:

• The first condition is that the job ID is AD_PRES and the salary is greater than 15,000.


• The second condition is that the job ID is SA_REP.

Therefore, the SELECT statement reads as follows:

“Select the row if an employee is a president and earns more than $15,000, or if the employee is a sales representative.”