# BETWEEN Condition

The BETWEEN condition is used in a WHERE clause to determine if a value is in a given…

## How is the **BETWEEN** condition used in SQL?

The **BETWEEN** condition is used in a 
**WHERE** clause to determine if a value
is in a given range. The range includes the 
upper and lower values specified

```sql
SELECT *
FROM Products
WHERE Price BETWEEN 10 AND 20
```

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

Updated: September 27, 2026

Source: https://www.ask-codey.com/glossary/between-condition