Answer Posted / anilchandu
Select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal)
where x,y are alias names.
If you want 3rd heighest salary then just replace 2 by 3
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain cascading triggers.
Is primary key indexed by default in oracle?
How to execute a stored procedure in oracle?
What do you mean by merge in oracle and how can we merge two tables?
Explain integrity constraints?
How to retrieve values from data fields in record variables?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Can we store images in oracle database?
How to create a new user account in oracle?
How to get last row id?
What is backup in Oracle?
What is the difference between hot backup and cold backup in oracle?
Can we call procedure inside function in oracle?
What is connection pooling in oracle?
What is oracle instant client?