How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 26014 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
How do you pronounce sql?
Explain what is a subquery ?
What is foreign key sql?
What do you mean by stored procedures?
Why is nosql good?
What is the use of <> sql?
how to escape special characters in sql statements? : Sql dba
What are the types of variables use in pl sql?
Can a composite key be null?
What is trigger in pl sql with examples?
How do I run a pl sql program?
define sql delete statement ? : Sql dba
What are operators available in sql?
How do I start pl sql?
what happens if null values are involved in expressions? : Sql dba
