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
- 7142 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
Can you create a synonym without having a table?
How to assign data of the deleted row to variables?
How to connect the oracle server as sysdba?
how may join possible between (requisition with purchase order)
Whether any commands are used for months calculation? If so, what are they?
What is difference between cartesian join and cross join?
What is a nvl function? How can it be used?
What is oracle data type?
How to set a transaction to be read only in oracle?
Explain the use of file option in exp command.
What is BBED in Oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to create a temporary table in oracle?
Explain compound trigger in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
