select firt_name, salary from employees a where 5=(select count(distinct

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

Question Posted / raju t.t

Answer Posted / raju t.t

select firt_name, salary from employees a where 5=(select
count(distinct salary from employees b where a.salary
<=b.salary);

Is This Answer Correct ?

6 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is composite primary key in sql?

996

What is rownum and rowid?

1030

What is a temporal table?

927

What is varchar used for?

1074

What does the file extension accdb stand for?

969

How does a covering index work?

956

Why do we use %rowtype & %type in plsql?

1046

What is a table in a database?

1043

How subquery works in sql?

1067

What is a database event trigger?

1158

How do I view an execution plan in sql?

979

Is microsoft sql free?

1095

What is secondary key?

932

Is inner join faster than left join?

1188

What does count (*) mean?

927