BETWEEN Operator

Purpose: Checks if a value lies within a specified range, inclusive.Syntax:

column_name BETWEEN value1 AND value2

Example:

SELECT * FROM employees WHERE salary BETWEEN 40000 AND 60000;

Explanation: This retrieves employees with salaries between 40,000 and 60,000.