SQL BETWEEN Operator

The BETWEEN operator is used to filter records within a specific range (inclusive).

Example of BETWEEN

SELECT first_name, last_name FROM Users
WHERE age BETWEEN 18 AND 30;
    

This query retrieves the names of users who are between 18 and 30 years old.