SELECT first_name, salary FROM employees E1 WHERE (3)

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

Question Posted / ajeet

Answer Posted / ajeet

SELECT first_name, salary FROM employees E1
WHERE (3) > (SELECT COUNT(DISTINCT(E2.salary))
FROM employees E2
WHERE E1.salary > E2.salary)

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you remove duplicates without using distinct in sql?

1019

What is number function in sql?

1018

What are the types of triggers in sql?

1144

Is time a data type in sql?

964

What is loop in pl sql?

1081

What are the uses of merge?

1228

How do I create a sql database?

1056

what is the use of friend function? : Sql dba

1063

How do you delete duplicates in sql query using rowid?

989

what is bdb (berkeleydb)? : Sql dba

1093

what are the disadvantages of mysql? : Sql dba

1210

Can we join 3 tables in sql?

1109

Why are sql stored procedures used?

1099

What is thread join () in threading?

1057

Can we create clustered index without primary key?

1002