Logical Predicate

A condition that combines or reverses other conditions with AND, OR, or NOT.

What does Logical Predicate do in a relational database?

Logical Predicate — A condition that combines or reverses other conditions with AND, OR, or NOT.

SELECT order_id
FROM purchase_order
WHERE total_amount >= 100 AND status = 'open';

Level: Novice · More Database terms at this level

Updated