📖
Theory
Understand the concept step by step
BETWEEN is used to select values within a range.
It is commonly used with numbers, dates and other comparable values.
The endpoints are included in the range.
💻
Example
See how the concept works in SQL
SQL
SELECT *
FROM products
WHERE price BETWEEN 500 AND 1000;📤
Output
Understand what the query produces
The query returns products priced from 500 through 1000.
📝
Practice
Test your understanding
Find employees whose salary is between 30000 and 60000.
❓
MCQs
Check your SQL knowledge
What is the main concept covered in BETWEEN Operator?
A.Filters values within a range
B.Creates a range table
C.Sorts values
D.Deletes a range
💼
Interview Questions
Prepare for SQL interviews
1
Interview Question
What does BETWEEN do?
2
Interview Question
Are the boundary values included?
3
Interview Question
Can BETWEEN be used with dates?