Interested to Buy Any Domain ? << Click Here >> for more details...
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 does sharding mean?
definition of cluster and non-clustered index?
How to rename a tablespace in oracle?
How to manage transaction isolation level?
What is bind variable in oracle 11g?
What is meant by recursive hints in oracle?
What is system global area (sga) in oracle?
What are the advantages of oracle 12c?
What is rich query?
How to experiment a data lock in oracle?
what are steps for interface? where is exchange rate defined in which table?
What is a procedure in oracle?
What are ddl statements in oracle?
ABOUT IDENTITY?
What are the differences between char and varchar2 in oracle?
