BETWEEN
The BETWEEN
command is used to select values within a given range. The values can be numbers, text, or dates.
The BETWEEN
command is inclusive: begin and end values are included.
The following SQL statement selects all products with a price BETWEEN 10 and 20: Continue reading SQL BETWEEN Keyword