SQL SERVER IN BETWEEN --查找sal在1500和3000之间的信息(包括1500和3000) select * from emp where sal >= 1500 and sal <=3000 --等价于 select * from emp where sal between 1500 and 3000