When working with relational DBMSs in which data is stored in a table form, users often face the task of fetching values that are (not included) in a certain range. The SQL language allows you to specify a set that should (should not) belong to a value by various options - an In operator, a Like operator, a combination of more or less conditions, and also an SQL Between statement. The description and examples in this article will be devoted to the last option.
Between statement in SQL: syntax, limitations
Literally, the between SQL statement translates as “between.” Its use allows you to set the “From and To” restriction to a specific field, and if the next value falls into the range, the predicate will take the value “True”, and the value will fall into the final selection.
The syntax of the operator is extremely simple:
Select * From table t1 Where t1.n between 0 and 7 |
, between , AND .
, between SQL:
- – .
- .
- .
between SQL . :
- « » .
- , , . , .
, . .
, . :
:
|
|
|
|
| _ | _ |
1 | | | | | 01.05.2014 | 1 |
2 | | | | | 21.09.2013 | 0 |
3 | | | | | 15.06.1998 | 1 |
4 | | | | | 25.12.2004 | 2 |
5 | | | | | 09.10.2007 | 0 |
6 | | | | | 12.01.2016 | 3 |
7 | | | | | 11.01.2017 | 1 |
8 | | | | | 31.03.2001 | 2 |
9 | | | | | 16.02.2009 | 0 |
sql between, , 2 3 :
SELECT .* FROM WHERE ._ between 2 and 3 |
, .
, 1 2005 31 2016 . , - . -- ( ) . MS Access «#». :
SELECT .*, ._ FROM WHERE . _ Between #1/1/2005# And #31/12/2016# |
, .
, between SQL .
between
, , – , . , :
SELECT .* FROM WHERE . between "" and "" ORDER BY 2 |
:
|
|
|
|
| _ | _ |
8 | | | | | 31.03.2001 | 2 |
1 | | | | | 01.05.2014 | 1 |
2 | | | | | 21.09.2013 | 0 |
, , , . ? , . «» «» . , . - , :
SELECT .* FROM WHERE . between "" and "" ORDER BY 2 |
.
, , , between, .