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 the difference between local and global temporary table?

1009

What are the different sql commands?

1024

how to check server status with 'mysqladmin'? : Sql dba

1028

Sql technical questions

1226

What has stored procedures in sql and how we can use it?

1031

How do we use distinct statement? What is its use?

995

What is before and after trigger?

911

How do I copy a table in sql?

948

Why do we create views in sql?

1081

What is sql stand for?

956

What are the string functions in sql?

950

What is multiple columns?

1028

What is a crud api?

920

How to pipe multiline string to isql?

981

What is foreign key sql?

956