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 Histogram?

1506

How to avoid duplicate records in a query?

952

Define select, insert, create, delete, update, drop keywords

997

What kind of join is join?

905

Which is faster truncate or drop?

983

What are the string functions in sql?

926

What does sign mean sql?

1022

What are some emotional triggers?

931

Explain the update statement in sql

918

what is an extent ? : Sql dba

1021

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1066

What is interval partition?

987

What is the advantage of index in sql?

917

what are the limitations of identity column? : Transact sql

1052

Is stored procedure faster than query?

916