find out the third highest salary?
Answer Posted / akshita
select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3
Is This Answer Correct ? | 43 Yes | 16 No |
Post New Answer View All Answers
How index is implemented in oracle database?
What is a nvl function? How can it be used?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
State and explain the different types of data models?
Explain the difference between sap and oracle?
How to create a table index?
Why do you create or replace procedures rather that drop and recreate.
How to loop through a cursor variable?
types of indexes and the rationale behind choosing a particular index for a situation.
What is meant by joins? List out the types of joins.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to convert a date to char in oracle? Give one example.
What is the data pump import utility?
How to use attributes of the implicit cursor in oracle?
Define oracle database