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 the difference between restoring and recovering?
How to convert csv to table in oracle?
How do I know if oracle is installed on windows?
What happens to the current transaction if the session is ended?
Write a syntax for update query in oracle?
How do I connect to oracle database?
How many types of tables supported by oracle?
How to drop a stored procedure in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How a tablespace is related to data files?
What is a cursor in oracle?
if you ctreate table identity
How can I create database in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
How to turn on or off recycle bin for the session?