How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 23587 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / kavitha nedigunta
select a.ename,a.sal
from(select ename,sal,
dense_rank() over( order by sal desc nulls last) rk
from emp)a
where rk =5;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is attribute indicator in pl sql?
what is data integrity? : Sql dba
Explain what is an index?
What are the methods of filing?
What is the purpose of primary key?
How do you truncate?
Why do we use cursors?
What is record type in pl sql?
What do you mean by stored procedures? How do we use it?
What is rowtype?
What is loop in pl sql?
What are the benefits of stored procedures?
what is data manipulation language? : Sql dba
What is sql analyzer?
How do I run a pl sql program?
