PLSQL QUESTION

Top questions

1. Display avg sal from emp without using avg function.
2. Display details of employees having sal > 3000 without using > operator.
3. Display details of employees having sal between >=2000 and <=5000 without using between operator.
4. Display deptno,job wise number of employees only for those deptno and job combination having atleast 3 employees.

single row subquery:-

1. Display details of employees working in the same dept as that of clerk.
2. Display 2nd lowest sal from emp.
3. Display details of employees having highest or lowest sal in emp table.
4. Display the deptno having highest number of employees among all the depts of emp table.
5. Display details of employees having 3rd highest sal in emp table.
6. Display deptno having total sal > the combined total sal of deptno 10&20.
7. Display details of employees working in a deptno having 2nd lowest number of employees.
8. Display deptno wise avs sal only for those depts having count of emp > the count of employee whose name starts with letter ‘a’ & sal >=2000.
9. Display details of manager to whome highest number of employees are reporting.
10. Display details of employees working under a manager having second lowest sal among all the managers of emp table.
11. Display details of manager having highest sal among all the managers of emp table.
12. Display details of employees to whome no body is reporting.
13. Display details of employees to whome at least one person is reporting.

                                                    multiple rows sub-query:-

1. Display the highest sal from emp table without using max function.
2. Display details of employees having sal > the avg sal of any of the depts of emp tables.
3. Display details of employees having sal > the highest sal of deptno 30 without using max function.
4. Display lowest sal from emp without using min function.
5. Display lowest sal from emp without using min and all.
6. Display details of employees working in a deptno having total sal > the highest sal of depts 10,20,30.

                                                          multicolumn subquery:-

1. Display details of employees having highest sal in their own dept.

                                                      co-related sub query:-

1. Display details of employees having sal > the avg sal of their own dept.
2. Display details of dept from dept table having employees in the same deptno of emptable.
3. Display highest sal from emp table without using max, all ,any(using corelated…).
4. Display the top three highest salaries from emp table.
5. Display details of employeees having 7th lowest sal in emp table.
6. Display details of employeees having 2nd lowest sal under every manager.
7. Display 3rd highest and 4th lowest sal from emp table.
8. Display 3rd lowest sal from emp using co related sub query.
9. Display deptno wise ist three highest sal from emp table.
10. Display details of employees having highest sal under every deptno using co related sub query.

                                                                 set operator:-

1. Display job from deptno 10,20,30 without displaying the same record more than once.
2. Display deptno wise ist 3 highest salaries without using count function.
3. Display job which are common to deptno 10,20&30.
4. Display job which belongs to deptno 10 only.
5. Display job which are common to deptno 10,20,30 without using intersection operator.