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.
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 |
Draw E-R diagram for many to many relationship ?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What do you mean by redo log file mirroring?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is a snapshot in oracle database?
What is coalesce function?
In what script is snap$ created? In what script is the scott/tiger schema created?
Can we commit inside a function in oracle?
What do database buffers contain?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
How are Indexes Update ?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,