Database SQL / Scripts for '#Between'

Database SQL / Scripts for '#Between' - 2 Query/Script(s) found

Sample 1. Get all records having date since a particular date

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

_{Like Feedback select query to_date sysdate get records between 2 dates get records for last 2 years}

Sample 2. Select Employee names having salary between 2000 to 3000 USD

Select EMPLOYEE_NAME from EMPLOYEE where SALARY between 2000 and 3000

_{Like Feedback between select}

Search Database SQL / Scripts