Select * from TABLE_NAME where CREATED_DATE_COLUMN >= SYSDATE - 10
Select count(*) from EMPLOYEE e where e.salary > 1000
select * from EMPLOYEE where JOINING_DATE between to_date('01-MAY-14', 'DD-MON-YY') and SYSDATE
Select D1.name , D2.name from Dept D1, Dept D2 where D1.employee_count < D2.employee_count
Select DEPT_NAME from DEPT where DEPT_ID not in ( Select distinct DEPT_ID from EMPLOYEE )
Select EMPLOYEE_NAME from EMPLOYEE where SALARY between 2000 and 3000