Using the BETWEEN sentence
SELECT * FROM EMPLOYEES WHERE SALARY BETWEEN 5000 AND 6000; SELECT * FROM EMPLOYEES WHERE HIRE_DATE BETWEEN ' 01-01-07 ' AND ' 01-01-08 '; SELECT * FROM EMPLOYEES WHERE FIRST_NAME BETWEEN 'Douglas' AND 'Steven';
SELECT * FROM EMPLOYEES WHERE SALARY BETWEEN 5000 AND 6000; SELECT * FROM EMPLOYEES WHERE HIRE_DATE BETWEEN ' 01-01-07 ' AND ' 01-01-08 '; SELECT * FROM EMPLOYEES WHERE FIRST_NAME BETWEEN 'Douglas' AND 'Steven';