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

What is sql and also describe types of sql statements?

1059

What is the difference between a subquery and a join?

1099

How to rename a table?

1012

How to Execute a Package in PL/SQL.?

1199

How do I get sql certification?

969

What are different types of queries in sql?

1121

What does count (*) do in sql?

1007

What is fmtonly in sql?

1079

Why stored procedure is better than query?

944

What are variables in pl sql?

1161

Why we use join in sql?

964

What is pl sql commands?

1045

What is sql analyzer?

1009

Who developed sql?

1039

what is a field in a database ? : Sql dba

1053