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

Sql technical questions

1198

What is left inner join in sql?

980

How do I count records in sql?

939

How global cursor can be declare with dynamic trigger ?

2145

What are all the ddl commands?

1112

What are tables and fields?

969

What is a design view?

883

how to present a past time in hours, minutes and seconds? : Sql dba

943

What is user in sql?

966

What is the basic form of sql query?

879

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1025

Is mariadb nosql?

988

Why do we use subquery?

942

what is sub-query? : Transact sql

1038

What is a natural join?

989