SQL Server中between(在某个范围取值)

1.创建数据表插入数据

create table emp
(
	empno int primary key,
	ename nvarchar(10),
	sal int
)
insert into emp values (7369,'smith',2800);
insert into emp values (7499,'allen',1500);
insert into emp values (7521,'ward',3500);
insert into emp values (7566,'jones',1300);
insert into emp values (7654,'martin',1600);
insert into emp values (7698,'blake',3000);

 二.between用法

在sal列中取1500和3000之间的值(包括1500和3000)
select * from emp where sal >=1500 and sal <=3000
--等于
select * from emp where sal between 1500 and 3000

 

在sal列中取小于1500或3000之前的信息(不包括1500和3000)
select * from emp where sal <1500 or >3000
--等于
select * from emp where sal not between 1500 and 3000