select * from EMPLOYEE where JOINING_DATE between to_date('01-MAY-14', 'DD-MON-YY') and SYSDATE
Select EMPLOYEE_NAME from EMPLOYEE where SALARY between 2000 and 3000