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
What is a connect identifier?
how to make an oracle object
query optmization techniques and quwry analyser+projects+ppts
What is oracle update statement with inner join ?
What is a tns service name?
Explain the use of parfile option in exp command.
How do I connect to oracle database?
How to invoke the original export import utilities?
What is the difference between sharding and partitioning?
How to define a cusotmer as a supplier in ORACLE R12
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?
How to connect to a local oracle 10g xe server?
How to invoke the data pump export utility?
How to drop an index in oracle?
What is open database communication (odbc) in oracle?
