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

Why use triggers in sql?

919

Does sql backup shrink transaction log?

938

Write a query to find the names of users that begin with "um" in sql?

946

Is sql pronounced sequel or sql?

1230

How much ram can sql express use?

948

How can I see all tables in sql?

1013

Why is pl sql needed?

894

What is sql and explain its components?

1033

how to show all tables with 'mysql'? : Sql dba

1076

Can unique keys be null?

871

Can sql developer connect to db2?

1004

Explain architecture of sql server notification services?

1012

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1996

What are the possible values that can be stored in a boolean data field?

963

What is spool?

1012