BETWEEN...AND操作符:显示在一个区间内的值,结果包含设定值。
例:查询工资在1000至4000之间的员工信息
SQL@itkaifang> SELECT empno,ename,sal,deptno FROM emp WHERE sal BETWEEN 1000 AND 4000; EMPNO ENAME SAL DEPTNO ---------- ---------- ---------- ---------- 7499 ALLEN 1600 30 7521 WARD 1250 30 7566 JONES 2975 20 7654 MARTIN 1250 30 7698 BLAKE 2850 30 7782 CLARK 2450 10 7788 SCOTT 3000 20 7844 TURNER 1500 30 7876 ADAMS 1100 20 7902 FORD 3000 20 7934 MILLER 1300 10 11 rows selected. SQL@itkaifang>