WHERE

A query clause keeping only rows for which its condition is true.

What does WHERE do in a relational database?

WHERE — A query clause keeping only rows for which its condition is true.

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

Level: Novice · More Database terms at this level

Updated September 27, 2026