Oracle SQL Query - Lab Exercise

    1.  List the details of the emps whose Salaries more than the employee BLAKE ?

    2.  List the emps whose Jobs are same as ALLEN ?

    3. List the emps who are senior to King ? 

    4.  List the Emps whose Sal is same as FORD or SMITH in desc order of Sal ?

    5.  List the emps Whose Jobs are same as MILLER or Sal is more than ALLEN ?

    6.  List the Emps whose Sal is > the total remuneration of the SALESMAN ?

    7.  List the emps whose jobs same as SMITH or ALLEN ?

    8. Write a Query to display the details of emps whose Sal is same ?

    8. Any jobs of deptno 10 those that are not found in deptno ?

    9. Write a Query to display the details of emps whose Sal is same ?

    10. List of emps of emp1 who are not found in emp2 ?

    11. Find the highest sal of EMP table ?

    12. Find details of highest paid employee ?