# 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.

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

Level: Novice · [More Database terms at this level](https://www.ask-codey.com/glossary/subjects/database/novice)

Updated: September 27, 2026

Source: https://www.ask-codey.com/glossary/where-database