select name from (select e.*, dense_rank() over (order by salary desc nulls

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

Question Posted / mrunali

Answer Posted / mrunali

select name from (select e.*, dense_rank() over (order by salary desc nulls last)as rn from emp e) where rn=5

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is compilation error in pl sql?

1025

What is dense_rank?

989

How do I tune a sql query?

1043

Is sql pronounced sequel or sql?

1340

What sql database should I use?

1201

What is a composite primary key?

1143

what are the limitations of identity column? : Transact sql

1163

Does view contain data?

1084

What is execute immediate?

1164

how do you control the max size of a heap table? : Sql dba

1026

What is sql constant?

1104

How to change sql*plus system settings?

1111

Is nosql relational?

1002

how to drop an existing view in mysql? : Sql dba

1107

what are the t string functions available in tsql? : Transact sql

1065