查询薪水为1600到3000的员工(第一种方式:采用>=、<=)
select empno,ename,sal from emp where sal >= 1600 and sal <= 3000;
查询薪水为1600到3000的员式(第二种方式:采用between…and…)
select empno,ename,sal from emp where sal between 1600 and 3000;
注:关于between … and … 它是包含最大值和最小值的
(了解)between … and … 同样也可用在字符上,用在字符上区间为:前闭后开;
select ename from emp where ename between "A" and "F";