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

Differentiate between pl/sql and sql?

1073

what is query cache in mysql? : Sql dba

993

What normalization means?

907

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

918

what are sequences

1622

Why procedure is used in sql?

977

Is sql better than access?

965

What is row_number () in sql?

935

Can we join same table in sql?

964

How do you declare a user-defined exception?

965

what are date and time intervals? : Sql dba

999

Do foreign keys improve performance?

968

Can function return multiple values in sql?

988

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1045

Is sql microsoft?

978