find out the third highest salary?
Answer Posted / alka
select min(salary)
from(select salary
from emp
order by salary desc
)
where rownum <=3
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
What is where clause in oracle?
What is bind variable in oracle 11g?
How to display row numbers with the records?
What are the differences between date and timestamp in oracle?
Explain the use of compress option in exp command.
What is logical backup in oracle?
Is postgres faster than oracle?
How to select some rows from a table in oracle?
How to drop a stored function?
How to use "while" statements in oracle?
What is different types of joins?
What is the simplest tool to run commands on oracle servers?
What is an oracle user role?
What are the execution control statements in oracle?
What are the types of trigger in oracle?