Interested to Buy Any Domain ? << Click Here >> for more details...
You have one employee table having 3 entries emp_id, Mgr_id
and salary. Mgr_id is also referencing emp_id. so now find
out the emp_id which are having the second highest salary,
under a particular manager.
- 3 Answers
- 8496 Views
- Amazon, HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar mrityunjay singh
SELECT *
FROM (SELECT EMPLOYEE_ID,MANAGER_ID,SALARY,DENSE_RANK() OVER(ORDER BY SALARY DESC)RN FROM EMPLOYEES WHERE MANAGER_ID='&ENTER_MANAGER_ID')WHERE RN < '&VALUE_UPTO'
/
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / rajesh
select * from (select
emp_id,mgr_id,salary,dense_rank()over(partition by mgr_id order by salary desc nulls last) rn from emp) where rn=2;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / chandra reddy
select empno,ename,deptno,sal from(select e.*,b.sal,rank()over(order by sal desc)send_h from em e join em1 b on e.empno=b.empno) where send_h=2
| Is This Answer Correct ? | 1 Yes | 1 No |
what is foreign key?
Explain about your project and its relation to the current job position you are applying to?
How do I connect to oracle database?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to write a query with a full outer join in oracle?
How different is ms access and oracle?
What is recovery manager(rman) backup in Oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
What privilege is needed for a user to insert rows to tables in another schema?
What are the components of Physical database structure of Oracle Database?
how to use sequence and what use of sequence cache
Explain cascading triggers.
Oracle General 
