sql函数between包含参数本身吗

Question

sql函数between包含参数本身吗

Answer 1

create table a1 (b1 int,b2 int)
insert a1 select '1','1'
insert a1 select '2','2'
insert a1 select '3','3'
insert a1 select '3','4'
select * from a1 where b2 between '1' and '2'
结果：
1 1
2 2
between 是包含参数本身的