BETWEEN

•    The BETWEEN operator is used to select values within a specified range, which can include numbers, text, or dates, and is inclusive of both the beginning and end values.

 

          SELECT column_name(s)

          FROM table_name

          WHERE column_name BETWEEN value1 AND value2;