范围查询：BETWEEN ... AND ...

查询 “在两个值之间” 的数据
相当于：>= 最小值 AND <= 最大值

create table studentdf
(

name nvarchar(10),
age int

);

insert into studentdf
values
('张三',18),
('李四',20),
('王五',16),
('赵七',22),
('钱七',25);

select * from student
where age between 18 and 22;

--等价写法
select *
from student
where age >=18 and age <=22;

--取反查询 not between
select *
from student
where age not between 18 and 22;

--日期范围
--建订单表
create table ordersf
(

order_no nvarchar(20),
create_time datetime

);

insert into ordersf
values
('A001','2025-01-05'),
('A002','2025-02-10'),
('A003','2025-03-15');

select *
from ordersf
where create_time between '2025-01-01' and '2025-02-28';