IN Predicate

A predicate testing whether a value equals any value in a list or subquery result.

What does IN Predicate do in a relational database?

IN Predicate — A predicate testing whether a value equals any value in a list or subquery result.

SELECT order_id
FROM purchase_order
WHERE status IN ('open', 'processing');

Level: Apprentice · More Database terms at this level

Updated September 27, 2026