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 are the differences between number and binary_float in oracle?
How to drop a stored procedure in oracle?
How to save query output to a local file?
How to find out what oracle odbc drivers are installed?
What are the roles of dba?
How to invoke the data pump import utility?
How does oracle handle read consistency?
How to use "while" statements in oracle?
Explain what are the different type of segments?
What is the fastest query method to fetch data from the table?
What do you understand by a database object?
What are a query and state the different types of queries and their uses?
What is difference between cartesian join and cross join?
How index is implemented in oracle database?
How to create a table index?