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
- 8726 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
Explain what are synonyms used for?
What are the tools for Oracle ?
What is an oracle user account?
Explain a synonym?
What is an index associated with a constraint?
What is the usage of merge statement?
What is a data dictionary and how can it be created?
How a database is related to tablespaces?
How does Oracle guarantee data integrity of data changes?
What language does oracle use?
What happens to the current transaction if the session is ended?
What is a table index in oracle?
How to invoke the data pump import utility?
How to display row numbers with the records?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
