find out the third highest salary?
Answer Posted / amit sutar
select min(salary)
from(select distinct(salary)
from employees
order by salary desc)
where rownum<=5;
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
Differentiate between translate and replace?
How to get a create statement for an existing table?
Why does oracle 9i treat an empty string as null?
Explain temporal data types in oracle
how the indexes are stored in the Oracle Database?
Is java required for oracle client?
How index is implemented in oracle database?
How to connect ms access to oracle servers?
How to empty your oracle recycle bin?
What is the difference between a user and a schema in oracle?
How to experiment a data lock in oracle?
What is the purpose of save points in oracle database?
How to use "startup" command to start default instance?
What is oracle thin client?
How to create a server parameter file?