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 are the limitations of check constraint?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is a proxy class?
How to count groups returned with the group by clause in oracle?
How to define a sub function?
What do you understand by a database object?
How to create a new oracle data file?
Describe an oracle table?
How many memory layers are in the oracle shared pool?
Is oracle a language?
How to revoke create session privilege from a user in oracle?
Give the various rollback segment states.
What is the relation of a user account and a schema?
Give the advantages and disadvantages of clusters.
How do I learn what codesets are available in oracle?
