0

Why is syntax "between" 3 "and" 8...

Why is syntax "between" 3 "and" 8, when the results produced are "all" beginning with 3 "and" ending with 8? 4 through 7 is what exists "between" 3 "and" 8. Just noticing the syntax is not very intuitive. Would be better to say 3 >= x <= 8.

9th Apr 2017, 6:56 PM
Amber Lee Nestor Gregory
2 Answers
+ 2
Just a convention that the limits belong to the interval selected. Works fine for me.
12th Apr 2017, 5:42 AM
Álvaro
0
select * from employee where ID BETWEEN 3 AND 8;
14th Apr 2017, 4:40 PM
Amol Pawar
Amol Pawar - avatar