Bi Consulting questions one telephone interview, presentation and customer meet and a qualification tests
. What is referential Integrity?
2. Display the names of the employees who earn highest salary in their respective departments.
SQL> select ename,sal,deptno from emp e where sal in(select max(sal) from emp m where m.deptno = e.deptno);
3. Find out top 5 earners of company.
SQL> select * from (select * from emp order by sal desc) where rownum <= 5;
4. Display the Employee name and Managers names.
SQL> select e.ename employee, m.ename manager from emp e, emp m where m.empno=e.mgr;