SELECT employee_name,min(salary) FROM ( select distinct salary from emplo

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

Question Posted / avi007

Answer Posted / avi007

SELECT employee_name,min(salary) FROM ( select distinct
salary from employee order by salary desc)
where rowno<6 group by employee_name;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is the stuff function and how does it differ from the replace function? : Sql dba

988

How to add a column ‘salary’ to a table employee_details?

953

What is java sql driver?

1035

What is blind sql injection?

990

What are different types of triggers?

1021

In a distributed database system, can we execute two queries simultaneously?

990

Why trigger is used in sql?

913

Are left and right joins the same?

997

What is the difference between partition and index?

919

Explain the purpose of %type and %rowtype data types with the example?

924

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

924

What does the file extension accdb stand for?

915

What is the difference between partitioning and sharding?

946

Is progress software supports to ( pl/sql )?

968

how many values can the set function of mysql take? : Sql dba

932