SQL Logical operators

Purpose

Logical Operators

Syntax

<condition1> AND <condition2>

NOT <condition>

<condition1> OR <condition2>

<condition1> XOR <condition2>

See Also

INSERT, SQL OPERATORS, SELECT, UPDATE

Description

Operator	Description
AND	True if <condition1> and <condition2> conditions are both true, otherwise False
NOT	True if the <condition> is false, otherwise False
OR	True if <condition1> or <condition2> is true or if both conditions are true, otherwise False
XOR	True if <condition1> or <condition2> is true but not both, otherwise False

Example

// AND
SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() AND ord_value > 10000;
ORDER BY name, paid_date
 
// NOT
SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() AND NOT ord_value BETWEEN 0 AND 10000;
ORDER BY name, paid_date
 
// OR
SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() OR ord_value > 10000;
ORDER BY name, paid_date
 
// XOR
SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() OR ord_value > 10000;
ORDER BY name, paid_date