If you need to choose records with the value in some range, you can use **BETWEEN** command:

SELECT id FROM songs
WHERE year BETWEEN 1970 AND 1990

SELECT id FROM songs
WHERE year >= 1970 AND year <= 1990



Note that it *includes* boundary values. You can use `BETWEEN` with `NOT` operator: `С NOT BETWEEN A AND B`, which is equal to `С<A OR С>B`.

## SQL BETWEEN for strings

If you apply `BETWEEN` to string values, you'll get all records from the table between these fields. Test the next example

SELECT title FROM songs
WHERE album BETWEEN 'Highway to Hell' AND 'If You Can Believe Your Eyes and Ears'

This course was created for very beginners in programming, for those who want to start learning such a popular language for work with databases. Nowadays, all the applications and services collect some data and work with it, and basic SQL syntax is a foundation for further work with other Database Management Systems.

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

SQL Between

SQL BETWEEN for strings

解答