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

What is an invalid partition table?

1035

What are the differences between implicit and explicit cursors?

1072

What is the use of index in hive?

1008

What is procedure and function in sql?

1004

What is fmtonly in sql?

1092

how to include comments in sql statements? : Sql dba

962

What do you mean by stored procedures? How do we use it?

1005

What is function and procedure in pl sql?

1059

What is the difference between explicit and implicit cursors in oracle?

1077

what is the difference between delete and truncate commands? : Sql dba

1076

Explain the difference between drop and truncate commands in sql?

1069

Explain isolation levels. : Transact sql

1079

How does sql store data?

925

What is embedded sql in db2?

1028

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

966