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'
/

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;

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

How do you bind variables in oracle?

0 Answers  

---

List out the components of logical database structure of oracle database.

0 Answers  

---

How to count duplicated values in a column in oracle?

0 Answers  

---

How to Remove the 3rd highest salary person record from table?

9 Answers   HCL, IBM,

---

In Oracle 10g, "g" Stands for what?

5 Answers   Mphasis,

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

What is a Shared SQL pool ?

2 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

What is the difference between post-database commit and post-form commit?

0 Answers  

---

How does the on-delete-cascade statement work?

0 Answers  

---

List out the types of joins.

0 Answers  

---