select a.ename,a.sal from(select ename,sal, dense

How to get employee name from employee table which is the
fiveth highest salary of the table

Question Posted / kavitha nedigunta

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

Please Help Members By Posting Answers For Below Questions

Which one is better sql or oracle?

1015

What is difference between sql and mysql?

1198

What is sql profiler in oracle?

1162

What is rank function in sql?

1072

What programs use sql?

1088

What is the max nvarchar size?

1032

What is the starting oracle error number? What is meant by forward declaration in functions?

1045

What is the difference between unique and primary key constraints?

1122

What is exit statement?

1064

What is a ddl command?

1157

Is time a data type in sql?

964

what is a composite primary key ? : Sql dba

1095

What are sql ddl commands?

1138

Is it possible to update views?

1007

What is a rank in sql?

1010