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
- 8696 Views
- Amazon, HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How will you identify oracle database software release?
What is a cursor in oracle?
Explain the use of indexes option in exp command.
How to write date and time literals in oracle?
How to convert a string to a date in oracle database?
What is the string concatenation operator in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to speed up webrick?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is oracle used for?
How to use existing values in update statements using oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to list all indexes in your schema?
What are the common oracle dba tasks?
What is the exact use of Collections?
