find out the third highest salary?
Answer Posted / naveen kumar
Hi everybody,
This is one way to get the third highest salary
select ROWNUM as RANK from (select * from emp order by sal)
where ROWNUM<=3
Is This Answer Correct ? | 11 Yes | 27 No |
Post New Answer View All Answers
What privilege is needed for a user to create views in oracle?
How to build data dictionary view an new database?
How to store pictures on to the database?
Can the query output be sorted by multiple columns in oracle?
how to join query for one source type is oracle another source type is sql server ?
What privilege is needed for a user to query tables in another schema?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the usage of save points in oracle database?
What is hash cluster in oracle?
what is a Nested Loop join?
How to create a new table in your schema?
What is the difference between $oracle_base and $oracle_home?
Explain user account with reference to oracle.
How to speed up webrick?
What is meant by raw datatype?