How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 23510 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / mani
select first_name,sal from
(
select first_name,sal from
(
select distinct
sal from employees
order by sal desc
)
where rownum < 5
order by sal
)
where rownum<2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the trigger in sql?
Does a user_objects view have an entry for a trigger?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
what is the difference difference between procedure and packages
How many clustered indexes can be created on a table?
What is primary key sql?
Is truncate ddl or dml?
What is bind variable in pl sql?
Explain character-manipulation functions?
What is the maximum rows in csv?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
what does it mean to have quoted_identifier on? : Sql dba
What is a temp table?
What are the properties of a transaction?
What is delimiter in pl sql?
