Databases · Junior · Question 18 of 75

What does `WHERE price BETWEEN 10 AND 20` include?

1Prices greater than 10 and less than 20
✓Correct answer: Prices from 10 to 20, including both 10 and 20
3Only 10 and 20

Explanation

BETWEEN is inclusive on both ends. With timestamps this can be surprising, so ranges like >= start AND < end are often safer.

Further reading

PostgreSQL: Comparison operators and NULL ↗

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.