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

Question

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.

Answer 1

Just a convention that the limits belong to the interval selected. Works fine for me.

Answer 2

select * from employee where ID BETWEEN 3 AND 8;