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

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'`

SELECT * FROM employee
WHERE NOT (fname = 'Ann')

AND

Both conditions must apply

SELECT * FROM employee
WHERE lname = 'Smith' AND fname = 'Ann'

Either condition can apply

SELECT * FROM employee
WHERE region = 'UK' OR region = 'FRA'

Logical Operators

See Also