Logical Operators

      

You can combine or modify search conditions using the standard logical operators listed in the following table. The operators are listed in the order that they are evaluated.

Operator Meaning Example
NOT Logical opposite of condition 
SELECT * FROM employee
WHERE NOT (fname = 'Ann')
AND Both conditions must apply 
SELECT * FROM employee
WHERE lname = 'Smith' AND fname = 'Ann'
OR Either condition can apply 
SELECT * FROM employee
WHERE region = 'UK' OR region = 'FRA'