SQL between query scope query

--sal for employee wages

SELECT * from EMP;

--Inquire about employee information in the [1500,3000] range of wages

SELECT * from emp where Sal >= and Sal <= 3000;

SELECT * from EMP where Sal between and 3000;

--The above two sentences have the same effect

--Query employee information for wages less than 1500 or greater than 3000

SELECT * from emp where Sal < or + < Sal;

SELECT * from emp where Sal is not between and 3000;

--The above two sentences have the same effect

--Query Payroll for 3000 employee information

SELECT * from emp where sal = 3000;

SQL between query scope query