some important queries

1)sql query to find second highest salary of employee?

A)select MAX(SAL) FROM EMP WHERE SAL NOT IN(SELECT MAX(SAL) FROM EMP);

2)SQL QUERY TO FIND MAX SALARY FROM EACH DEPARTMENT?

A)SELECT DEPTNO,MAX(SAL) FROM EMP GROUP BY DEPTNO;

3)SQL QUERY TO FIND MAX SALARY FROM EACH DEPT NAME?

A)SELECT DNAME,MAX(SAL) FROM EMP E RIGHT JOIN DEPT D ON E.DEPTNO =    D.DEPTNO GROUP BY DNAME;

4)WRITE SQL QUERY TO DISPLAY THE CURRENT DATE?

A)SELECT SYSDATE FROM DUAL;

5)WRITE AN SQL QUERY TO PRINT THE NAME OF THE DISTINCT EMPLOYEE WHOSE DOB IS BETWEEN 01/01/1970 T0 31/12/1980?

A)SELECT DISTINCT ENAME FROM EMP WHERE HIREDATE BETWEEN  TO_DATE('01/01/1980','DD/MM/YYYY') AND TO_DATE('31/01/1981','DD/MM/YYYY');