1.between 小 and 大 闭区间 SQL> select sal from emp where sal between 950 and 2450; SAL ---------- 1600 1250 1250 2450 1500 1100 950 1300 2. >=小 and <=大 SQL> select sal from emp where sal >=950 and sal <=2450; SAL ---------- 1600 1250 1250 2450 1500 1100 950 1300