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 the difference between drop and truncate commands?

1062

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1004

Is not null in sql?

997

What is sql dialect?

1120

What is the difference between left outer join and left join?

995

What is the plv (pl/vision) package offers?

1053

How do you declare a variable in pl sql?

1029

describe mysql connection using mysql binary. : Sql dba

1068

What are the types of keys?

996

Define commit?

1008

Explain correlated query work?

1056

What is primary key in db?

1011

What are the types of sql commands?

1103

How would you reference column values before and after you have inserted and deleted triggers?

1065

Why are aggregate functions called so?

947