Between

The BETWEEN operator selects values within a specified range.

Syntax

SELECT <columns>
FROM <table-name>
WHERE <column-name> BETWEEN <value-1> AND <value-2>;

Example

SELECT *
FROM Companies
WHERE founded BETWEEN 1920 AND 1960;