Skip to main content
SQL โ€ข LESSON 45

BETWEEN

How can we filter values that fall inside a specific range?

Beginnerโฑ 3 Minutesโญ 580 XP
๐Ÿค” THE QUESTION

How can we filter values that fall inside a specific range?

๐Ÿ’ก WHAT IS IT?

The BETWEEN operator filters rows where a column value falls inclusively within a specified lower and upper boundary.

๐ŸŽฏ WHAT IS IT USED FOR?

Salary brackets, age ranges, price filters, score intervals in analytical queries.

๐Ÿ’ป EXAMPLE
SELECT name, salary
FROM employees
WHERE salary BETWEEN 60000 AND 100000;

๐ŸŽฏ Mission Objectives

Practice typing production-grade SQL code for BETWEEN.

  • โœ“ BETWEEN operator
  • โœ“ Inclusive range
  • โœ“ Numeric filtering
  • โœ“ WHERE clause